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_28 (date VARCHAR, result VARCHAR, venue VARCHAR)
system
What Date had a Result of draw, and a Venue of lord's?
user
SELECT date FROM table_name_28 WHERE result = "draw" AND venue = "lord's"
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_28 (date VARCHAR, result VARCHAR, venue VARCHAR)<|im_end|>
<|im_start|>user
What Date had a Result of draw, and a Venue of lord's?<|im_end|>
