OneAdvanced interview question

SQL queries which included (Group by , Sort )