EY interview question

sql questions on left join