Cyberbit interview question

SQL question including order by and filtering few rows from the output