SLB interview question

SQL basics - Joins, subqueries