Infosys interview question

SQL queries based on order by.