Dell Technologies Interview Question

Solve a DB question with multiple joins