2025-02-18     2025-02-19     2025-02-20

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