Stdle #44 · grouping · 2026-07-20
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