Deloitte Interview Question

Inner join and nested queries