Infosys interview question

SQL concepts