By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| (No column name) | sum_2018 | sum_2019 | total |
|---|---|---|---|
| newyork | 4 | 6 | 10 |
| toronto | 8 | 12 | 20 |
| Total | 12 | 18 | 30 |
Warning: Null value is eliminated by an aggregate or other SET operation.