By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
code | state | ordered | invoiced | sold | avgOrdQty | avgSold |
---|---|---|---|---|---|---|
COD1 | confirmed | 30 | 11 | 30 | 3 | 3 |
COD1 | confirmed | 10 | 20 | 10 | 3 | 10 |
COD2 | confirmed | 2 | 2 | 2 | 1 | 1 |
code | sold | SUM(T.avgSold) |
---|---|---|
COD1 | 30.00000000000000000000000000000000000000 | 6 |
COD2 | 2.00000000000000000000000000000000000000 | 1 |
code | state | ordered | invoiced | sold | avgOrdQty | avgSold |
---|---|---|---|---|---|---|
COD1 | confirmed | 30 | 11 | 30 | 3 | 3 |
COD1 | confirmed | 10 | 20 | 10 | 3 | 3 |
COD2 | confirmed | 2 | 2 | 2 | 1 | 1 |
code | SUM(T.avgSold) |
---|---|
COD1 | null |
COD2 | null |
code | sold | SUM(T.avgSold) |
---|---|---|
COD1 | 30 | 6 |
COD2 | 2 | 1 |