SHL Global Interview Question

SQL queries, Joins, clauses, Conditions