Mu Sigma Interview Question

SQL : Joins and clauses