← Back to archive

Stdle #18 · nulls · 2026-06-24

What does this SQL snippet output?

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

CREATE TABLE t(id INTEGER, name TEXT);
INSERT INTO t VALUES (1,'a'),(2,NULL),(3,'c');
SELECT COUNT(*) FROM t WHERE name <> 'a'
NULLs
4 attempts left

Answer & explanation