BMO Financial Group Interview Question

This was a SQL question which required querying a database using joins.