Comment by Rapzid

It would be a crap shoot if I nailed the syntax for creating the tables and the foreign key constraint.

This might be something I'd ask about in an interview, but I'd be looking for general knowledge about the columns, join, and key constraint. Wouldn't expect anyone to write it out; that's the boring part.