Sorting
1 / 15
EasyOutput prediction

ORDER BY multiple columns

Given this table (employees):

idnamedeptsalary
1AliceSales70000
2BobEng90000
3CarolEng80000
4DaveSales70000

What does this query return?

SELECT name FROM employees ORDER BY dept ASC, salary DESC;

← → arrow keys to navigate

Sign in to save your progress.