By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| City | id | Flag |
|---|---|---|
| A | 1A | TypeA |
| A | 2A | TypeA |
| A | 3A | TypeA |
| A | 4A | TypeA |
| A | 5A | TypeB |
| B | 1B | TypeA |
| B | 2B | TypeA |
| B | 3B | TypeA |
| B | 4B | TypeA |
| B | 5B | TypeA |
| B | 6B | TypeB |
| D | 1D | TypeA |
| D | 2D | TypeA |
| D | 3D | TypeA |
| D | 4D | TypeA |
| D | 5D | TypeA |
| D | 6D | TypeA |
| D | 7D | TypeA |
| D | 8D | TypeB |