What is the highest number of points scored when Acadie-Bathurst had 4 tied games, less than 257 goals, and over 72 games played?
CREATE TABLE table_name_10 (points INTEGER, games VARCHAR, tied VARCHAR, goals_for VARCHAR)
SELECT MAX(points) FROM table_name_10 WHERE tied = "4" AND goals_for < 257 AND games > 72
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (points INTEGER, games VARCHAR, tied VARCHAR, goals_for VARCHAR) Question: What is the highest number of points scored when Acadie-Bathurst had 4 tied games, less than 257 goals, and over 72 games played? [/INST] SELECT MAX(points) FROM table_name_10 WHERE tied = "4" AND goals_for < 257 AND games > 72 </s>