IGATE Interview Question

About joins and project