CREATE TABLE player (id INTEGER, team TEXT, score INTEGER);
INSERT INTO player VALUES (1, 'Red', 10), (2, 'Blue', 10), (3, 'Red', 25);
-- sort by team, then score descending within each team
SELECT team, score
FROM player
ORDER BY team ASC, score DESC;

tie-break with more columns