SELECT MONTH(dt_column) month_data, COUNT(*) month_count
    FROM table
    GROUP BY MONTH(dt_column);
    ORDER BY month_count DESC;