Is it possible to make such a request, so that in one approach to get data? So that he does not perform several times changing only the digit of the month, and give the number of records for each?

SELECT COUNT(name) AS jun FROM calendar WHERE month = 6;

    1 answer 1

    I think so

     SELECT COUNT(name) AS cnt, month AS month FROM calendar GROUP BY month;

    And add WHERE if needed.