Altimetrik interview question

SQL Joins and Subqueries based