SQL Playground

Read-only sandbox matching the official PostgreSQL tutorial . Write queries locally in psql as you follow along.

Tutorial examples

Schema

weather city, temp_lo, temp_hi, prcp, date
cities name, location
empsalary empno, salary, depname, enroll_date
accounts name, branch_name, balance
branches name, balance
geo_cities name, population, elevation
capitals name, population, elevation, state
myview name, temp_lo, temp_hi, prcp, date, location

SQL query