Deloitte Interview Question

About joins and query tables