2025-02-14     2025-02-15     2025-02-16

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