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_27 (award VARCHAR, year VARCHAR, result VARCHAR, category VARCHAR)
system
For the category of most popular star with a result of won for 2007, what was the award?
user
SELECT award FROM table_name_27 WHERE result = "won" AND category = "most popular star" AND year = 2007
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_27 (award VARCHAR, year VARCHAR, result VARCHAR, category VARCHAR)<|im_end|>
<|im_start|>user
For the category of most popular star with a result of won for 2007, what was the award?<|im_end|>
