What is the largest number for SHTS for the San Jose earthquakes with MINS larger than 2700?
CREATE TABLE table_name_23 (shts INTEGER, club VARCHAR, mins VARCHAR)
SELECT MAX(shts) FROM table_name_23 WHERE club = "san jose earthquakes" AND mins > 2700
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (shts INTEGER, club VARCHAR, mins VARCHAR) Question: What is the largest number for SHTS for the San Jose earthquakes with MINS larger than 2700? [/INST] SELECT MAX(shts) FROM table_name_23 WHERE club = "san jose earthquakes" AND mins > 2700 </s>