6 synthetic rows in sensor_deliveries.
Queries return up to 500 rows. The sample data is synthetic.
The sample data and query stay in your browser.
Expected result
Query results and chart
Query result
Two grains, two averages
Six deliveries represent four measurements. Both averages use the same fictional values but answer different questions.
| deliveries | measurements | delivered_mean_ppm | measurement_mean_ppm |
|---|---|---|---|
| 6 | 4 | 700 | 675 |
Synthetic example output. Run the query against your own event schema and thresholds before using it for operational decisions.
Need joins and a learning path?
Practice joins with a SaaS dataset
The SQL Lab connects accounts, product events, API requests, LLM requests, jobs, and billing events across five guided analyses.
What the playground checks
The playground checks that the read-only query runs on the sample rows and returns the expected result. When you first run a query, your browser downloads a specific DuckDB version from jsDelivr. It does not send your SQL or sample data with that request. Telemetry recipes are separately planned with Apache DataFusion, the engine used by Telemetry. DuckDB and DataFusion are distinct SQL engines, so validate any edited syntax with the DataFusion SQL reference before using it in production.