Table: kansascity_brass_stats
Columns: year
division
league
regular_season
playoffs
open_cup

Question: What is the latest year that 6th, Heartland is regular season?
SQL: SELECT MAX("year") FROM kansascity_brass_stats WHERE "regular_season" = '6th, Heartland'

Question: Which regular season contains playoffs in division finals?
SQL: SELECT "regular_season" FROM kansascity_brass_stats WHERE "playoffs" = 'Division Finals'

Question: What is the lowest year that regular season is 4th, Rocky Mountain?
SQL: SELECT MIN("year") FROM kansascity_brass_stats WHERE "regular_season" = '4th, Rocky Mountain'