Wheebox interview question

Two SQL queries on Joins.