Infosys Interview Question

Plsql concepts, to write simple queries