I want the lowest points for tries of 39 and goals more than 0
CREATE TABLE table_name_1 (points INTEGER, tries VARCHAR, goals VARCHAR)
SELECT MIN(points) FROM table_name_1 WHERE tries = 39 AND goals > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (points INTEGER, tries VARCHAR, goals VARCHAR) Question: I want the lowest points for tries of 39 and goals more than 0 [/INST] SELECT MIN(points) FROM table_name_1 WHERE tries = 39 AND goals > 0 </s>