By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| q | student | alumni |
|---|---|---|
| q1 | 1.500000 | 2.500000 |
| q2 | 2.000000 | 1.000000 |
| q3 | 2.250000 | null |
Warning: Null value is eliminated by an aggregate or other SET operation.