What is in it
One row per order, January to April 2026, eleven columns. All customers and companies are made up.
Column | Type | Example |
|---|---|---|
order_id | number | 1001 |
date | date | 2026-01-04 |
customer | text | Jordan Alvarez |
company | text | Acme Supply Co |
country | text | Netherlands |
channel | text | Direct, Partner or Marketplace |
product | text | Starter Plan, Pro Plan or Business Plan |
units | number | 2 |
unit_price | number | 49.00 |
revenue | number | 98.00 |
status | text | paid, refunded or pending |
revenue is always units times unit_price.
Facts to check against
30 orders: 25 paid, 3 refunded and 2 pending.
Paid revenue by channel: Direct 4563, Marketplace 2474, Partner 2432.
The same table is built into the SQL Query Playground as its sample, so a class can start without downloading anything.
Ideas
SQL: the 45-minute exercise uses exactly this table.
Spreadsheets: a pivot table of revenue by country and product, then the same figures with SUMIFS.
Statistics: the mean and median order value, and why they differ.
License
The data is released into the public domain under CC0 1.0. Use it however you like, no credit needed.