for 1940 south carolina hurricane, what's the tropical cyclone season?
(AND meteorology.tropical_cyclone_season (JOIN meteorology.tropical_cyclone_season.tropical_cyclones m.0b3ddt))