Fictional extract. Static reading copy of an actual DuckDB-Wasm 1.29.0 browser execution; this page does not run a database or submit work.
| Location | Source rows | Units |
|---|---|---|
| North | 2 | 11 |
| South | 1 | 4 |
location,units North,6 South,4 North,5
SELECT location, COUNT(*)::INTEGER AS source_rows, SUM(units)::INTEGER AS units FROM stock GROUP BY location ORDER BY location;
Independent reconciliation: North6+5=11; South4; three source rows and15units overall. The original engine source and native execution records accompany the article.