Aditya Birla Group interview question

Asked a Sql query involving Subqueries.