how do you summarize the dates?

June 18, 2022 June 18, 2022 / 1 minute of reading

Use group by!

select date, sum(qty) sum_qty
from mytable
group by date
order by date

CLICK HERE to find out more related problems solutions.