Took care of the first on pretty easily. However the 2nd question has got me. Jason my date column is actually4 columns month, day, year and ampm. So I'm not sure how to fit this into your answer.
This is what I have so far (stop laughing), it obviously does nothing.
SELECT SUM ( tripmanifest.Air) AS numCount
FROM tripmanifest GROUP BY tripmanifest.`Month`