Sorting
6 / 15
EasyOutput prediction

Multi-column sort with different directions

Given this table (scores):

idplayerlevelscore
1AliceA300
2BobB200
3CarolA500
4DaveB400

What does this query return?

SELECT player FROM scores ORDER BY level ASC, score DESC;

← → arrow keys to navigate

Sign in to save your progress.