Fractal interview question

SQL statements based on multiple joins.