ADP Interview Question

queries using group by Clause