SELECT DATE_FORMAT(invoice.date, '%M') AS `month`, COUNT(*) AS `invoice_count`, SUM(`invoice`.`amount`) AS `turnover` FROM `invoice` WHERE `date` BETWEEN '2008-01-01' AND '2008-12-31' GROUP BY MONTH(`invoice`.`date`)