Sales Volume by Product

For each product return the total quantity sold. Return product_id and total_quantity.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

product_id	total_quantity
3	10
4	20
2	20

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid