Practice · Education · Easy
Return a single number: the count of universities in the table, as a column named n.
Runs in your browser. No signup needed.
universities(...). Use COUNT(*).
SELECT COUNT(*) AS n
FROM universities;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
COUNT(*) counts rows; COUNT(column) skips NULLs in that column — a subtle but important difference. (SQLite docs)