Fractal Interview Question

SQL statements based on multiple joins.