Table: soccer_stats
Columns: year
division
league
regular_season
playoffs
open_cup

Question: what being the maximum year where regular season is 4th, northwest
SQL: SELECT MAX("year") FROM soccer_stats WHERE "regular_season" = '4th, Northwest'

Question: what is the total number of playoffs where regular season is 6th, southwest
SQL: SELECT COUNT("playoffs") FROM soccer_stats WHERE "regular_season" = '6th, Southwest'

Question: what is the maximum division
SQL: SELECT MAX("division") FROM soccer_stats

Question:  what's the league where regular season is 2nd, northwest
SQL: SELECT "league" FROM soccer_stats WHERE "regular_season" = '2nd, Northwest'

Question: what are all the regular season where year is 2011
SQL: SELECT "regular_season" FROM soccer_stats WHERE "year" = 2011