What is the latest year that 6th, Heartland is regular season?
CREATE TABLE table_1241987_1 (year INTEGER, regular_season VARCHAR)
SELECT MAX(year) FROM table_1241987_1 WHERE regular_season = "6th, Heartland"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1241987_1 (year INTEGER, regular_season VARCHAR) Question: What is the latest year that 6th, Heartland is regular season? [/INST] SELECT MAX(year) FROM table_1241987_1 WHERE regular_season = "6th, Heartland" </s>