Deloitte Interview Question

HQL basic query