Sun Life interview question

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