What is the highest week that has espn 8:30pm as the TV time?
CREATE TABLE table_name_74 (week INTEGER, tv_time VARCHAR)
SELECT MAX(week) FROM table_name_74 WHERE tv_time = "espn 8:30pm"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (week INTEGER, tv_time VARCHAR) Question: What is the highest week that has espn 8:30pm as the TV time? [/INST] SELECT MAX(week) FROM table_name_74 WHERE tv_time = "espn 8:30pm" </s>