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_18 (purpose VARCHAR, band VARCHAR, frequency VARCHAR)
system
Band of am, and a Frequency of 0 846 has what purpose?
user
SELECT purpose FROM table_name_18 WHERE band = "am" AND frequency = "0 846"
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_18 (purpose VARCHAR, band VARCHAR, frequency VARCHAR)<|im_end|>
<|im_start|>user
Band of am, and a Frequency of 0 846 has what purpose?<|im_end|>
