By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | CarType | PctUnitsSold |
|---|---|---|
| 2 | SUV | 125.000000000000 |
| 1 | Sedan | 250.000000000000 |
| null | Total | 375.000000000000 |
| null | Sedan | 66.666666666666 |
| null | SUV | 33.333333333333 |
Warning: Null value is eliminated by an aggregate or other SET operation.