SQL Playground

A blank SQL editor connected to a fresh copy of the demo shop database. Write any queries — including CREATE, INSERT and DELETE — and press Run (or Ctrl+Enter). Every run starts from the original data.

Schema reference

Table	Columns
customers	id, name, email, city, country, signup_date
products	id, name, category, price, stock
orders	id, customer_id → customers, order_date, status
order_items	order_id → orders, product_id → products, quantity, unit_price
employees	id, first_name, last_name, email, department_id → departments, job_title, salary, hire_date, manager_id → employees
departments	id, name, location

See The Demo Database for the full data and how the tables relate.

Ideas to try

• Which city has the most customers?
• What's the average order value per month?
• Which employees earn more than their department's average?
• Create a reviews table, add a few reviews and join them to products.