How to count the total number of people from one date?

Question

MySQL

I have a database.

I need to query the total number of people (num_psng) per month (date_flying)
For example, for May it turns out 75.
How can I do this?

Answer 1

If by day, then

SELECT date_fluing, SUM(num_psng) FROM ... GROUP BY date_fluing

If by months, then

SELECT DATE_FORMAT(date_fluing, '%Y-%m'), SUM(num_psng) FROM ... GROUP BY DATE_FORMAT(date_fluing, '%Y-%m')

If only for one month (for example, May), then

SELECT SUM(num_psng) FROM ... WHERE DATE_FORMAT(date_fluing, '%Y-%m') = '2017-05'