IfOnly Interview Question

SQL Left Join question