Multi-column sort with different directions

Question

Accepted Answer

Level sorts A before B (ascending). Within level A, scores sort descending: Carol (500) before Alice (300). Within level B, scores sort descending: Dave (400) before Bob (200). Each sort key applies independently within the groups created by the keys before it.

id	player	level	score
1	Alice	A	300
2	Bob	B	200
3	Carol	A	500
4	Dave	B	400