EdGe Networks interview question

1) Some SQL (medium), Elasticsearch queries (easy) 2) OOPS question