Dell Technologies interview question

Solve a DB question with multiple joins