By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ITEM | D1Q | D2Q | D3Q | D4Q | D5Q | D6Q | D7Q | TOTQ | TOTA |
---|---|---|---|---|---|---|---|---|---|
T1 | 3 | 2 | null | null | null | null | null | 5 | 7.50 |
T2 | null | 2 | null | null | 3 | null | null | 5 | 15.00 |
T3 | null | null | 2 | 1 | null | null | null | 3 | 7.50 |
Warning: Null value is eliminated by an aggregate or other SET operation.