IfOnly interview question

SQL Left Join question