What is the canadian air date when the US air date is 24 august 2012?
CREATE TABLE table_30012404_4 (canadian_air_date VARCHAR, us_air_date VARCHAR)
SELECT canadian_air_date FROM table_30012404_4 WHERE us_air_date = "24 August 2012"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_30012404_4 (canadian_air_date VARCHAR, us_air_date VARCHAR) Question: What is the canadian air date when the US air date is 24 august 2012? [/INST] SELECT canadian_air_date FROM table_30012404_4 WHERE us_air_date = "24 August 2012" </s>