Infosys interview question

technical SQL questions about queries