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_27441210_12 (weeks_at__number1 INTEGER, artist VARCHAR)
system
How many weeks was K.Maro at #1?
user
SELECT MAX(weeks_at__number1) FROM table_27441210_12 WHERE artist = "K.Maro"
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_27441210_12 (weeks_at__number1 INTEGER, artist VARCHAR)<|im_end|>
<|im_start|>user
How many weeks was K.Maro at #1?<|im_end|>
