2025-04-21     2025-04-22     2025-04-23

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