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_9 (name VARCHAR, regional_county_municipality VARCHAR, code VARCHAR)
system
What is the name for the regional county municipality of d'autray and a code less than 52017?
user
SELECT name FROM table_name_9 WHERE regional_county_municipality = "d'autray" AND code < 52017
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_9 (name VARCHAR, regional_county_municipality VARCHAR, code VARCHAR)<|im_end|>
<|im_start|>user
What is the name for the regional county municipality of d'autray and a code less than 52017?<|im_end|>
