Deloitte Interview Question

SQL ques on nested joins.