You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_30 (tries_against VARCHAR, try_diff VARCHAR, points_for VARCHAR)
system
How many Tries against has a Try diff of –17 and Points for smaller than 80?
user
SELECT COUNT(tries_against) FROM table_name_30 WHERE try_diff = "–17" AND points_for < 80
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_30 (tries_against VARCHAR, try_diff VARCHAR, points_for VARCHAR)<|im_end|>
<|im_start|>user
How many Tries against has a Try diff of –17 and Points for smaller than 80?<|im_end|>
