Infosys Interview Question

one SQL query which involved joins