How many shows had 12.46 total viewers?
CREATE TABLE table_23793770_2 (title VARCHAR, total_viewers__in_millions_ VARCHAR)
SELECT COUNT(title) FROM table_23793770_2 WHERE total_viewers__in_millions_ = "12.46"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_23793770_2 (title VARCHAR, total_viewers__in_millions_ VARCHAR) Question: How many shows had 12.46 total viewers? [/INST] SELECT COUNT(title) FROM table_23793770_2 WHERE total_viewers__in_millions_ = "12.46" </s>