By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 4
| shop | region | waste | avgregionwaste | lift |
|---|---|---|---|---|
| a | CA | 10 | 15.00 | 0.67 |
| b | CA | 20 | 15.00 | 1.33 |
| c | LA | 32 | 37.00 | 0.86 |
| d | LA | 42 | 37.00 | 1.14 |
SELECT 4
CREATE TABLE
INSERT 0 4
| shop | region | waste | avgregionwaste | lift |
|---|---|---|---|---|
| a | CA | 10 | 15.00 | 0.67 |
| b | CA | 20 | 15.00 | 1.33 |
| c | LA | 32 | 37.00 | 0.86 |
| d | LA | 42 | 37.00 | 1.14 |
SELECT 4