Manulife interview question

Using SQL to join tables