Meta interview question

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