How many viewers were there on 1august1964?
CREATE TABLE table_1723080_1 (viewers__in_millions_ VARCHAR, broadcast_date VARCHAR)
SELECT viewers__in_millions_ FROM table_1723080_1 WHERE broadcast_date = "1August1964"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1723080_1 (viewers__in_millions_ VARCHAR, broadcast_date VARCHAR) Question: How many viewers were there on 1august1964? [/INST] SELECT viewers__in_millions_ FROM table_1723080_1 WHERE broadcast_date = "1August1964" </s>