Which Points have a Lost smaller than 1, and Games larger than 7?
CREATE TABLE table_name_81 (points INTEGER, lost VARCHAR, games VARCHAR)
SELECT MAX(points) FROM table_name_81 WHERE lost < 1 AND games > 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_81 (points INTEGER, lost VARCHAR, games VARCHAR) Question: Which Points have a Lost smaller than 1, and Games larger than 7? [/INST] SELECT MAX(points) FROM table_name_81 WHERE lost < 1 AND games > 7 </s>