The SQL problems beginners really meet: what each one means, why it happens and how to fix it. Every example was run, and every message is copied from the real output.
Why SQLite says misuse of aggregate COUNT(), why PostgreSQL says a column must appear in the GROUP BY clause, why SQLite sometimes gives a wrong answer with no error at all, and how WHERE and HAVING differ.
Why SQLite says "no such column", how single quotes fix the usual cause, the four other causes (a typo, another table, an alias, an old table) and the errors that look alike. With a table you can run.
Error explained · · 6 min read
1 beginner error a week
One common error, what it means and how to fix it, in a short email. Free, and you can unsubscribe in any email.
Get stuck on an error like these?
Twenty minutes with the AI tutor, right in your browser. It reads your real code and output, and hints instead of handing you the answer.