2025-06-06     2025-06-07     2025-06-08

countrysubdivs match countrycode

number of errors=0
number of warnings=0

select cc,countrycode,type from countrysubdivtype,countrysubdivision where countrysubdivision.countrysubdivtypeid=countrysubdivtype.typeid and cc<>countrycode

[]

cc	countrycode	type