EY Interview Question

sql questions on left join