2025-05-13     2025-05-14     2025-05-15

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