How many episodes have a premier date of july 24, 2006
CREATE TABLE table_2140071_7 (external_link VARCHAR, premier_date VARCHAR)
SELECT COUNT(external_link) FROM table_2140071_7 WHERE premier_date = "July 24, 2006"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2140071_7 (external_link VARCHAR, premier_date VARCHAR) Question: How many episodes have a premier date of july 24, 2006 [/INST] SELECT COUNT(external_link) FROM table_2140071_7 WHERE premier_date = "July 24, 2006" </s>