← Back to archive

Stdle #43 · grouping · 2026-07-19

What does this SQL snippet output?

A past puzzle — fully playable. 4 attempts, hints on wrong guesses.

CREATE TABLE sales(region TEXT, amt INTEGER);
INSERT INTO sales VALUES ('N',10),('N',30),('S',20),(NULL,5);
SELECT COUNT(*) FROM (SELECT region FROM sales GROUP BY region)
Grouping
4 attempts left

Answer & explanation