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_48 (penanced VARCHAR, total VARCHAR)
system
How many were penanced for a total of 7666?
user
SELECT penanced FROM table_name_48 WHERE total = "7666"
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_48 (penanced VARCHAR, total VARCHAR)<|im_end|>
<|im_start|>user
How many were penanced for a total of 7666?<|im_end|>
