RBC interview question

Behavior Questions + How to explain Left Join