SELECT
    MONTHNAME(fld_addedon) AS month,
    COUNT(*) AS total_enquiries
FROM
    tbl_query
WHERE
    YEAR(fld_addedon) = 2023
    AND MONTH(fld_addedon) IN (7, 8, 9, 10, 11, 12)
GROUP BY
    MONTH(fld_addedon);



SELECT MONTHNAME(created_at) AS month, COUNT(*) AS total_enquiries FROM bravo_enquiries WHERE YEAR(created_at) = 2023 AND MONTH(created_at) IN (7, 8, 9, 10, 11, 12) GROUP BY MONTH(created_at);


SELECT MONTHNAME(created_at) AS month, COUNT(*) AS total_enquiries FROM bravo_enquiries WHERE YEAR(created_at) = 2023 AND MONTH(created_at) IN (7, 8, 9, 10, 11, 12) GROUP BY month ORDER BY month;