Infosys interview question

one SQL query which involved joins