I want to know the player with tries more than 1 and position of hooker with points less than 54
CREATE TABLE table_name_18 (player VARCHAR, position VARCHAR, tries VARCHAR, points VARCHAR)
SELECT player FROM table_name_18 WHERE tries > 1 AND points < 54 AND position = "hooker"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (player VARCHAR, position VARCHAR, tries VARCHAR, points VARCHAR) Question: I want to know the player with tries more than 1 and position of hooker with points less than 54 [/INST] SELECT player FROM table_name_18 WHERE tries > 1 AND points < 54 AND position = "hooker" </s>