SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE cities (city, country, population);
✓
INSERT INTO cities VALUES
  ('city1', 'country1', 1000), ('city2', 'country1', 1500), ('city2', 'country1', 500), 
  ('city4', 'country2', 700), ('city5', 'country2', 500), ('city6', 'country2', 800);
✓
select
    country,
    count(*),
    max(population),
    city
from
    cities
group by
    country
having
    count(*) > 1


country
count(*)
max(population)
city


country1
3
1500
city2

country2
3
800
city6