Meta Interview Question

Fairly involved SQL questions involving joins.