Meta Interview Question

Standard SQL-style join problems with some redundant tables thrown in