Stock CSV: captured query reading

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.

Registered stock.csv, grouped by location
LocationSource rowsUnits
North211
South14

Original CSV

location,units
North,6
South,4
North,5

Executed SQL

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.