add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
id location product quantity
1 London Macbook 10
2 London iMac 15
3 San Francisco Macbook 50
4 San Francisco iMac 70
5 San Francisco Mac Pro 40
6 Shanghai iMac 70
7 Shanghai Macbook 150
location sum
null 405
Shanghai 220
San Francisco 160
London 25
location product sum
London iMac 15
London Macbook 10
London null 25
San Francisco iMac 70
San Francisco Macbook 50
San Francisco Mac Pro 40
San Francisco null 160
Shanghai iMac 70
Shanghai Macbook 150
Shanghai null 220
null null 405
location product sum
All locations All products 405
London All products 25
London iMac 15
London Macbook 10
San Francisco All products 160
San Francisco iMac 70
San Francisco Macbook 50
San Francisco Mac Pro 40
Shanghai All products 220
Shanghai iMac 70
Shanghai Macbook 150
location product sum
All locations All products 405
All locations iMac 155
All locations Macbook 210
All locations Mac Pro 40
London All products 25
London iMac 15
London Macbook 10
San Francisco All products 160
San Francisco iMac 70
San Francisco Macbook 50
San Francisco Mac Pro 40
Shanghai All products 220
Shanghai iMac 70
Shanghai Macbook 150