Sun Life Interview Question

Group by, having by, order by, sql query to extract information requested