I can't get my head around this, but I think I should be able to do it
using just SQL without writing a program.
I have a simple table that looks like:
Each date will have 1 row with the total sales for that day.
and I want to sum the weekly totals so it looks like:
So for each week, it will sum the sales for Monday through Saturday and
provides a total column. It will do this for all the rows in the table. If
there was a years worth of data, there would be 52 weeks hence 52 rows of
data would be produced.
Some days may be missing if it is a holiday, which means I can't guarantee
each week will have a sales row for Monday or Saturday.
Do I need to write a program to do this? Or can it be done with SQL? TIA