Manulife Interview Question

Using SQL to join tables