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, PRIMARY KEY (canadian_air_date))
select canadian_air_date from table_30012404_4 where us_air_date = "24 august 2012"