Moody's interview question

Typical SQL questions (4 joins)