SQL dashboard reference — AskYourDatabase, September 30, 2026

Run reference.sql only in a fresh PostgreSQL test session. All objects are temporary.
The script contains synthetic data, an order-grain view, and three dashboard queries.
It is not an AskYourDatabase import file or an AI benchmark.
Local validation: PGlite PostgreSQL WASM; adapt and rerun in your target database.

Definitions: paid USD order cohort for tenant A; Sep 1 inclusive to Sep 5 exclusive.
Refunds known before the end date reduce the original order day. This is not cash flow.
Expected KPI: 27900 net cents, 4 orders, 6975 average cents.
Daily net cents: 10500,13400,4000,0. Regions: North22500/3, South5400/1.
Use the article checklist for filter, refresh, error, access and empty-state acceptance.
The tenant filter illustrates calculation scope; it does not implement authorization.