I want to know the highest rank with placings more than 123 and points greater than 88.06
CREATE TABLE table_name_75 (rank INTEGER, placings VARCHAR, points VARCHAR)
SELECT MAX(rank) FROM table_name_75 WHERE placings > 123 AND points > 88.06
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (rank INTEGER, placings VARCHAR, points VARCHAR) Question: I want to know the highest rank with placings more than 123 and points greater than 88.06 [/INST] SELECT MAX(rank) FROM table_name_75 WHERE placings > 123 AND points > 88.06 </s>