FareHarbor Interview Question

SQL exercise for grouping results from two joined tables