Stackoverflow question example code

create table table1(item varchar(20), week int(1), sales int(2)); insert into table1 values('ice cream', 1, 17); insert into table1 values('cupcake', 1, 25); insert into table1 values('cookie', 1, 22); insert into table1 values('ice cream', 2, 20); insert into table1 values('cupcake', 2, 20); insert into table1 values('cookie', 2, 2); insert into table1 values('ice cream', 3, 17); insert into table1 values('cupcake', 3, 9); insert into table1 values('cookie', 3, 10); insert into table1 values('ice cream', 4, 10); insert into table1 values('cupcake', 4, 7); insert into table1 values('cookie', 4, 24); insert into table1 values('ice cream', 5, 12); insert into table1 values('cupcake', 5, 24); insert into table1 values('cookie', 5, 9); insert into table1 values('ice cream', 6, 13); insert into table1 values('cupcake', 6, 16); insert into table1 values('cookie', 6, 20); insert into table1 values('ice cream', 7, 2); insert into table1 values('cupcake', 7, 10); insert into table1 values('cookie', 7, 9); insert into table1 values('ice cream', 8, 25); insert into table1 values('cupcake', 8, 16); insert into table1 values('cookie', 8, 21); SELECT item, SUM(sales) OVER (PARTITION BY week order by item) AS total_sales FROM TABLE1 GROUP BY item;