By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 4 Duplicates: 0 Warnings: 0
Records: 16 Duplicates: 0 Warnings: 0
| question | sum(ai.value * a.weight) / sum(a.weight) | avg(ai.value) |
|---|---|---|
| a | 3.6363636363636367 | 3.5000 |
| b | 2.8484848484848486 | 3.0000 |
| c | 2.666666666666667 | 2.5000 |
| d | 2.8181818181818183 | 3.0000 |