Synechron interview question

SQL queries asked mostly on group by