What is the highest points of the club with less than 9 draws, 11 wins, and more than 40 goals?
CREATE TABLE table_name_28 (points INTEGER, goals_for VARCHAR, draws VARCHAR, wins VARCHAR)
SELECT MAX(points) FROM table_name_28 WHERE draws < 9 AND wins = 11 AND goals_for > 40
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (points INTEGER, goals_for VARCHAR, draws VARCHAR, wins VARCHAR) Question: What is the highest points of the club with less than 9 draws, 11 wins, and more than 40 goals? [/INST] SELECT MAX(points) FROM table_name_28 WHERE draws < 9 AND wins = 11 AND goals_for > 40 </s>