Piramal Enterprises interview question

Sql query using group by clause