2025-02-22     2025-02-23     2025-02-24

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