SQL
Compatible approach for DATA DARE questions — optional unless a question explicitly constrains it.
SQL queries against the dataset tables.
Questions
DD-RET-001-Q001 — Total net sales for the period
DD-HRM-002-Q001 — Headcount at 31 December 2025
DD-PRJ-001-Q001 — Projects in the portfolio
DD-REA-002-Q001 — Establish the gross amount charged to tenants
DD-INV-002-Q001 — One stock ledger after the append
DD-LOG-003-Q001 — Total shipment volume
DD-HRM-005-Q001 — Pay codes across the three catalogs
DD-GLT-001-Q001 — Does the ledger balance?
DD-MFG-001-Q001 — Total order volume
DD-RET-002-Q001 — Total net sales for the period
Datasets
DD-RET-001 — Daily Grocery Sales and Store Performance
DD-HLT-001 — Outpatient Service Performance
DD-REA-001 — Residential Rental Income and Occupancy
DD-MFG-001 — Production Output and Plant Efficiency
DD-LOG-001 — Shipment Delivery Performance and Fleet Efficiency
DD-TRF-001 — Basic Data Cleaning and Shaping
DD-GLT-001 — Mizan Retail: Sales Up, Profit Down — Journals, Trial Balance and Budget
DD-BVA-001 — Mizan Manufacturing: The Customer Who Left — Budget, Reforecasts and Actual
DD-PRC-001 — Mizan Manufacturing: Orders, Deliveries and Invoices — Procurement & Spend
DD-PRJ-001 — Mizan Retail: Stores on Time, on Budget? — Project Management & Project Accounting
DD-HRM-001 — Mizan Retail: Who Works Here, and What Do They Cost? — HR & Payroll Analytics
DD-ARC-001 — Mizan Manufacturing: Sales Up, Cash Slow — Accounts Receivable & Collections