Infosys Interview Question

SQL queries based on order by.