RBC Interview Question

Questions involving SQL Joins, aggregate functions