2025-04-24     2025-04-25     2025-04-26

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