Freddie Mac Interview Question

Design a query using joins and group by clauses.