Report question

Question: left join with condition for right table in mysql