Synechron Interview Question

SQL queries asked mostly on group by