UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	North Dakota	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	South Dakota	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Nebraska	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Kansas	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Minnesota	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Iowa	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Missouri	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Wisconsin	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Illinois	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Kentucky	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Indiana	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Michigan	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Ohio	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Manitoba	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Northwest Territories	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Yukon	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '14' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Nunavut	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Maryland	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Delaware	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Pennsylvania	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	New Jersey	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	New York	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Connecticut	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Rhode Island	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Massachusetts	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Vermont	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	New Hampshire	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Maine	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Nova Scotia	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	New Brunswick	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Newfoundland	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Quebec	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Ontario	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Prince Edward Island	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '18' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	District of Columbia	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Texas	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Oklahoma	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Arkansas	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Louisiana	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Tennessee	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Mississippi	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Alabama	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Georgia	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Florida	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	North Carolina	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	South Carolina	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	West Virginia	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '15' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Virginia	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	California	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Washington	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Oregon	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Idaho	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Nevada	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Utah	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Arizona	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Wyoming	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Montana	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Alaska	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Hawaii	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Arizona	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	New Mexico	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Colorado	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	British Columbia	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Alberta	';
UPDATE schools, seasons_teams, teams SET teams.division_id = '12' WHERE seasons_teams.team_id = teams.id AND schools.id = teams.school_id AND schools.state = '	Saskatchewan	';