2025-04-01     2025-04-02     2025-04-03

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