db2 sql: how to sum quantities group by next 4 weeks?
I have table, with quantity and a date.
How to have the sum of quantity group by the next 4 weeks?
some thing like that:
week 45, quantity 234
week 46, quantity 30
week 47, quantity 34
week 48, quantity 89?