learn sql
Hands-on lessons with a real Postgres database running right in your browser. Edit the queries, run them, and check your answers. Nothing to install, and you can't break anything: reload the page and the data starts fresh.
Pull rows and columns out of a table, filter them with WHERE, sort with ORDER BY, and cap the results with LIMIT.
Combine rows from related tables with INNER JOIN and LEFT JOIN, and use a LEFT JOIN to find rows with no match.
Summarize data with COUNT, SUM, and AVG, group rows with GROUP BY, and filter groups with HAVING.
An empty editor and the sample databases. Write any query you like.