Crédit Agricole interview question

left joins on sql questions