By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 17 Duplicates: 0 Warnings: 0
Table 'fiddle.temp_sale' doesn't exist
Statement prepared
product_name | SUM(`sales`) | week-30 | week-31 | week-32 |
---|---|---|---|---|
Micro | 300 | 100 | 200 | 0 |
x | 1930 | 0 | 700 | 1230 |
y | 2010 | 300 | 0 | 1710 |
z | 2140 | 0 | 400 | 1740 |