what tropical cyclone, that affected areas including grand canyon, is in the season 1974 atlantic hurricane season?
(AND meteorology.tropical_cyclone (AND (JOIN meteorology.tropical_cyclone.affected_areas m.0vmt) (JOIN meteorology.tropical_cyclone.tropical_cyclone_season m.03by27)))