-- name: SumBaz :many
SELECT bar, coalesce(sum(baz), 0) AS quantity
FROM foo
GROUP BY 1;