Why does PostgreSQL reject this query?
-- PostgreSQL SELECT price * qty AS total FROM items WHERE total > 100; -- ERROR: column "total" does not exist
totalis a reserved keywordWHEREruns before the alias existsASaliases need double quotes- Expressions can't be aliased in
SELECT
Logically
Play SQL & Databases ▸
WHERE is evaluated before the SELECT list, so its aliases are not visible; repeat the expression or use a subquery.