What is the largest WNBA game average with 9,290 (4th) is the average, and less than 157,934 is the total for the year?
CREATE TABLE table_name_11 (wnba_game_average INTEGER, average VARCHAR, total_for_year VARCHAR)
SELECT MAX(wnba_game_average) FROM table_name_11 WHERE average = "9,290 (4th)" AND total_for_year < 157 OFFSET 934 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (wnba_game_average INTEGER, average VARCHAR, total_for_year VARCHAR) Question: What is the largest WNBA game average with 9,290 (4th) is the average, and less than 157,934 is the total for the year? [/INST] SELECT MAX(wnba_game_average) FROM table_name_11 WHERE average = "9,290 (4th)" AND total_for_year < 157 OFFSET 934 ROWS </s>