Wheebox Interview Question

Two SQL queries on Joins.