Haven Workshop: fictional April/May2026 snapshot, no personal data. orders.csv:24 order rows, order_id text primary key, order_date ISO date, channel(web/store/partner), region(East/West), status(completed/cancelled). order_lines.csv:48 rows, line_id unique, order_id foreign key, product_id foreign key, quantity positive integer, historical unit_price_cents nonnegative integer cents. products.csv:3 unique products with current descriptive attributes. Line value=quantity*historical unit_price_cents. Reporting includes completed status only:21 orders,42 lines,119000cents. April11/EUR600;May10/EUR590. June unavailable, not observed zero. These are completed line values, not complete accounting revenue. SQL exercises use SQLite3.39+; the ready fixture has synthetic data only.
