I made the tables quick to go through them. It could do with more data really but its got a few rows.
I had the same idea, but in an SQL Fiddle
Didn't even know that there was such a thing as SQL Fiddle. That's going to come in handy, beyond this quiz, thanks.
In the same vain here are some very quickly put together answers if anyone is interested. I haven't tested these so they may not work. If you see any errors please let me know :)
At least this should be quicker in an interview situation than the usual "normalize this database" or "given this situation, define a database schema".