Sorting & Limiting
Sorting with ORDER BY (ASC/DESC) and limiting the number of results with LIMIT.
Simple enough for a 5-year-old to understand
ORDER BY
CREATE TABLE k(name TEXT, score INTEGER);INSERT INTO k VALUES ('Alex', 95), ('Sam', 88), ('Zoe', 99);SELECT name FROM k ORDER BY score DESC;