2025-02-15     2025-02-16     2025-02-17

geonamesadmcode missing

number of errors=0
number of warnings=0
Group=chkGrpPostalCode

select count(*) as num,countrycode from zip_code where geonamesadmcode is null and admin1geonameid >0 group by 2

num	countrycode