Stdle #6 · nulls · 2026-06-12
What does this SQL snippet output?
A past puzzle — fully playable. 4 attempts, hints on wrong guesses.
CREATE TABLE t(v INTEGER);INSERT INTO t VALUES (5),(NULL),(15);SELECT SUM(CASE WHEN v > 10 THEN 1 ELSE 0 END) FROM tNULLs