Siemens interview question

some sql questions, mainly about left join, no difficult.