CREATE TABLE table_30012404_4 (canadian_air_date VARCHAR2, us_air_date VARCHAR2)

What is the canadian air date when the US air date is 24 august 2012?
SELECT canadian_air_date FROM table_30012404_4 WHERE us_air_date = "24 August 2012"
SELECT "canadian_air_date" FROM "table_30012404_4" WHERE "24 August 2012" = "us_air_date"