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 artist (name VARCHAR, year_join VARCHAR, country VARCHAR)
system
Show all artist names and the year joined who are not from United States.
user
SELECT name, year_join FROM artist WHERE country <> 'United States'
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 artist (name VARCHAR, year_join VARCHAR, country VARCHAR)<|im_end|>
<|im_start|>user
Show all artist names and the year joined who are not from United States.<|im_end|>
