By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
state | Y1999 | Y2000 | Y2001 |
---|---|---|---|
CA | 150 | 200 | 100 |
OH | 40 | 50 | 40 |
WS | 50 | null | 200 |
Warning: Null value is eliminated by an aggregate or other SET operation.
state | Y1999 | Y2000 | Y2001 |
---|---|---|---|
CA | 150 | 200 | 100 |
OH | 40 | 50 | 40 |
WS | 50 | 0 | 200 |