Sorting & limiting
Exercise · SQL & Querying

Predict, then run it

Predict the output

stalls(id, name) = (1,amber),(3,copal),(4,drift) — stall 2 closed since page 1 (which showed amber, brass). Fetch page 2 by keyset from the last id seen (2):

SELECT name FROM stalls WHERE id > 2 ORDER BY id LIMIT 2;

Predict the exact output.