SQL simulation lab

Query, join, filter, and visualize business data.

tables4

result rows0

last runtime0ms

Schema

warehouse

customers6 rows

idnameregionsegmentsignup_month

orders8 rows

idcustomer_idorder_datestatuschannel

products4 rows

idproductcategoryunit_price

order_items11 rows

order_idproduct_idquantity

Join map

customers.id

orders.customer_id

orders.id

order_items.order_id

products.id

order_items.product_id

Query Runner

ready

SQL editor

SELECT customers.region, SUM(order_items.quantity * products.unit_price) AS revenue
FROM customers
JOIN orders ON customers.id = orders.customer_id
JOIN order_items ON orders.id = order_items.order_id
JOIN products ON products.id = order_items.product_id
WHERE orders.status = 'paid'
GROUP BY customers.region
ORDER BY revenue DESC;

Run a query to inspect joined and filtered data.

Visual Output

bar

Run a query with at least one label and one numeric column to draw a chart.

Local Dataset Builder

localStorage only

Dataset name

Table name

Rows JSON array

Relations JSON array

Saved datasets stay in this browser only. Use table names directly in SQL, for example: SELECT id, name FROM customers;

Create a dataset, add one or more tables, then save it locally.

Query Result

0 rows

No rows returned.