By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Column1 | Column2 | NewColumn | Column3 |
---|---|---|---|
Silver | Bridge | 400 | Aaron |
Silver | Pool | 410 | Aaron |
Silver | Garden | 427 | Aaron |
Silver | Lawn | 591 | Aaron |
Silver | Shed | 1337 | Aaron |
Diamond | Meadow | 492 | Mike |
Gold | Gas | 360 | Jud |
Gold | Electricity | 1991 | Jud |
Warning: Null value is eliminated by an aggregate or other SET operation.