ANZ Interview Question

Advanced problems with Joins and conditional expressions.