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_47 (broadcasts__tv__1 INTEGER, series VARCHAR, us_release_date VARCHAR)
system
What is the sum of Broadcasts (TV) 1, when Series is "3 4", and when US Release Date is "27 December 2006"?
user
SELECT SUM(broadcasts__tv__1) FROM table_name_47 WHERE series = "3 4" AND us_release_date = "27 december 2006"
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_47 (broadcasts__tv__1 INTEGER, series VARCHAR, us_release_date VARCHAR)<|im_end|>
<|im_start|>user
What is the sum of Broadcasts (TV) 1, when Series is "3 4", and when US Release Date is "27 December 2006"?<|im_end|>
