Moody's Interview Question

Typical SQL questions (4 joins)