2025-02-11     2025-02-12     2025-02-13

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