[Solved] How to sum and group values using MySQL ?

SELECT
    SUM(how_many) AS per_day,
    `date`
FROM
    cigaretes
GROUP BY
    DATE(`date`)