Short, hands-on Postgres exercises. Sign in to run them in your own sandbox.
Pull rows out of a table — projection, filtering, and ordering.
Add data with INSERT, change it with UPDATE, see what happened with RETURNING.
Predicates beyond = — comparisons, AND/OR, IS NULL, LIKE, IN, BETWEEN.
Roll rows up — COUNT, SUM, AVG, GROUP BY, and HAVING.
Pull rows from two or more tables — INNER and LEFT JOIN, ON vs USING.