Stdle #20 · grouping · 2026-06-26
What does this SQL snippet output?
A past puzzle — fully playable. 4 attempts, hints on wrong guesses.
CREATE TABLE t(g TEXT, v INTEGER);INSERT INTO t VALUES ('a',1),('a',3),('b',10);SELECT g, SUM(v) FROM t GROUP BY g HAVING SUM(v) > 3 ORDER BY gGrouping