Which position is the highest to have less than 54 goals, a loss of 7 and a goal difference higher than 23?
CREATE TABLE table_name_9 (position INTEGER, goal_difference VARCHAR, goals_against VARCHAR, losses VARCHAR)
SELECT MAX(position) FROM table_name_9 WHERE goals_against < 54 AND losses = 7 AND goal_difference > 23
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (position INTEGER, goal_difference VARCHAR, goals_against VARCHAR, losses VARCHAR) Question: Which position is the highest to have less than 54 goals, a loss of 7 and a goal difference higher than 23? [/INST] SELECT MAX(position) FROM table_name_9 WHERE goals_against < 54 AND losses = 7 AND goal_difference > 23 </s>