Table: pro40_stats
Columns: season
1st_division
relegated
2nd_division
promoted

Question: What was relegated in the 2006 season?
SQL: SELECT "relegated" FROM pro40_stats WHERE "season" = '2006'

Question: What season was Norwich Union League promoted?
SQL: SELECT "season" FROM pro40_stats WHERE "promoted" = 'norwich union league'

Question: What was relegated in the 2nd division of middlesex?
SQL: SELECT "relegated" FROM pro40_stats WHERE "2nd_division" = 'middlesex'

Question: What is the 1st division when the 2nd division is national league?
SQL: SELECT "1st_division" FROM pro40_stats WHERE "2nd_division" = 'national league'