ADP interview question

queries using group by Clause