Table: nhiaa_football_stats
Columns: year
division_i
division_ii
division_iii
division_iv
division_v

Question: With a Division II of Portsmouth, what is the Division IV?
SQL: SELECT "division_iv" FROM nhiaa_football_stats WHERE "division_iii" = 'portsmouth'

Question: What Division III has Bishop Brady in Division V and Hanover in Division IV?
SQL: SELECT "division_iii" FROM nhiaa_football_stats WHERE "division_v" = 'bishop brady' AND "division_iv" = 'hanover'