2025-02-19     2025-02-20     2025-02-21

no country has more than one capital

number of errors=0
number of warnings=0

select count(*),countrycode from geoname where featurecode = 'PPLC' group by 2 having count(*)>1

count	countrycode