By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| CITY | COUNTRY | POPULATION |
|---|---|---|
| a1 | a | 1 |
| a2 | a | 3 |
| a3 | a | 3 |
| b1 | b | 1 |
| b3 | b | 3 |
| b2 | b | 3 |
| c1 | c | 1 |
| COUNTRY | CT_CITIES | HIGHEST_POPULATION | BIGGEST_CITY |
|---|---|---|---|
| a | 3 | 3 | a2 |
| b | 3 | 3 | b3 |
| CITY | COUNTRY | POPULATION |
|---|---|---|
| a1 | a | 1 |
| a2 | a | 3 |
| a3 | a | 3 |
| b1 | b | 1 |
| b3 | b | 3 |
| b2 | b | 3 |
| c1 | c | 1 |
| COUNTRY | CT_CITIES | HIGHEST_POPULATION | BIGGEST_CITY |
|---|---|---|---|
| a | 3 | 3 | a2 |
| b | 3 | 3 | b3 |