Infosys interview question

Plsql concepts, to write simple queries