SHL Global interview question

SQL queries, Joins, clauses, Conditions