Mu Sigma interview question

SQL : Joins and clauses