By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | city | avg | months | average |
---|---|---|---|---|
1 | New-York | 20 | 3 | 20 |
2 | New-York | 19 | 6 | 20 |
3 | New-York | 15 | 12 | 20 |
4 | New-York | 15 | 24 | 20 |
11 | Miami | 28 | 1 | 28 |
12 | Miami | 25 | 4 | 28 |
13 | Miami | 21 | 12 | 28 |
14 | Miami | 22 | 15 | 28 |
15 | Miami | 20 | 24 | 28 |