By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| person_name | category | average_num |
|---|---|---|
| angela | 1 | 24.000000 |
| angela | 2 | 22.500000 |
| john | 1 | 18.000000 |
| steve | 1 | 14.500000 |
| steve | 2 | 13.500000 |
11 rows affected
| person_name | category | average_num |
|---|---|---|
| angela | 1 | 24.000000 |
| angela | 2 | 22.500000 |
| john | 1 | 18.000000 |
| steve | 1 | 14.500000 |
| steve | 2 | 13.500000 |