RBC interview question

Questions involving SQL Joins, aggregate functions