SQL sandbox · runs in your browser

Query the Ecommerce Sales & Returns dataset with SQL

Write SQL against the real tables without downloading or installing anything. Pick a starter query or write your own; nothing you run leaves your browser.

Answer 5 graded questions Download the full dataset →

Starter queries

Loading the SQL engine and dataset sample…

ecommerce-sales.sql⌘/Ctrl + Enter

Loading editor…

Ctrl/⌘ + Enter runs the query. Results show up to 200 rows.

Tables

6 tables

customers5 cols

customer_idTEXT PRIMARY KEY
created_atTEXT NOT NULL
country_codeTEXT NOT NULL
acquisition_channelTEXT NOT NULL
customer_segmentTEXT NOT NULL

products6 cols

product_idTEXT PRIMARY KEY
skuTEXT NOT NULL
product_nameTEXT NOT NULL
categoryTEXT NOT NULL
unit_costREAL NOT NULL
list_priceREAL NOT NULL

orders9 cols

order_idTEXT PRIMARY KEY
customer_idTEXT NOT NULL
ordered_atTEXT NOT NULL
order_statusTEXT NOT NULL
currencyTEXT NOT NULL
subtotalREAL NOT NULL
tax_amountREAL NOT NULL
shipping_amountREAL NOT NULL
order_totalREAL NOT NULL

order_items7 cols

order_item_idTEXT PRIMARY KEY
order_idTEXT NOT NULL
product_idTEXT NOT NULL
quantityINTEGER NOT NULL
unit_priceREAL NOT NULL
discount_amountREAL NOT NULL
line_totalREAL NOT NULL

payments6 cols

payment_idTEXT PRIMARY KEY
order_idTEXT NOT NULL
paid_atTEXT NOT NULL
payment_methodTEXT NOT NULL
payment_statusTEXT NOT NULL
amountREAL NOT NULL

refunds6 cols

refund_idTEXT PRIMARY KEY
payment_idTEXT NOT NULL
order_idTEXT NOT NULL
refunded_atTEXT NOT NULL
refund_reasonTEXT NOT NULL
amountREAL NOT NULL

A linked sample of the full release

Every Nth customer, account, or product is kept with all of its related rows, so joins work and keys match. Totals are smaller than in the download.

customers160 of 20,000
products933 of 1,200
orders803 of 100,000
order_items1,845 of 237,537
payments853 of 105,388
refunds69 of 7,910