What is the highest comp for ratings less than 52.8 and yards less than 0?
CREATE TABLE table_name_97 (comp INTEGER, rating VARCHAR, yards VARCHAR)
SELECT MAX(comp) FROM table_name_97 WHERE rating < 52.8 AND yards < 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (comp INTEGER, rating VARCHAR, yards VARCHAR) Question: What is the highest comp for ratings less than 52.8 and yards less than 0? [/INST] SELECT MAX(comp) FROM table_name_97 WHERE rating < 52.8 AND yards < 0 </s>