SQL sandbox · runs in your browser

Query the Inventory & Supply Chain 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…

inventory-supply-chain.sql⌘/Ctrl + Enter

Loading editor…

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

Tables

7 tables

suppliers5 cols

supplier_idTEXT PRIMARY KEY
supplier_nameTEXT NOT NULL
country_codeTEXT NOT NULL
lead_time_daysINTEGER NOT NULL
reliability_scoreREAL NOT NULL

products6 cols

product_idTEXT PRIMARY KEY
supplier_idTEXT NOT NULL
skuTEXT NOT NULL
categoryTEXT NOT NULL
unit_costREAL NOT NULL
reorder_pointINTEGER NOT NULL

warehouses4 cols

warehouse_idTEXT PRIMARY KEY
warehouse_nameTEXT NOT NULL
regionTEXT NOT NULL
capacity_unitsINTEGER NOT NULL

inventory_opening_balances5 cols

opening_balance_idTEXT PRIMARY KEY
product_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
balance_dateTEXT NOT NULL
opening_unitsINTEGER NOT NULL

purchase_orders7 cols

purchase_order_idTEXT PRIMARY KEY
supplier_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
ordered_atTEXT NOT NULL
expected_atTEXT NOT NULL
received_atTEXT
statusTEXT NOT NULL

purchase_order_lines6 cols

purchase_order_line_idTEXT PRIMARY KEY
purchase_order_idTEXT NOT NULL
product_idTEXT NOT NULL
quantity_orderedINTEGER NOT NULL
quantity_receivedINTEGER NOT NULL
unit_costREAL NOT NULL

inventory_movements8 cols

movement_idTEXT PRIMARY KEY
product_idTEXT NOT NULL
warehouse_idTEXT NOT NULL
movement_atTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL
purchase_order_line_idTEXT
transfer_idTEXT

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.

suppliers68 of 250
products68 of 2,500
warehouses12
inventory_opening_balances816 of 30,000
purchase_orders1,383 of 18,000
purchase_order_lines1,383 of 53,967
inventory_movements3,693 of 138,436