2024-12-23     2024-12-24     2024-12-25

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