Miscellany

SELECT   `from`,  MONTHNAME(`when`) AS 'Month',  IFNULL(YEAR(`when`),'Total') AS 'Year',  SUM(    IF(      split_comp = TRUE       OR sold_status = 16,      0.5,      1    )  ) / COUNT(DISTINCT MONTH(`when`), YEAR(`when`) ) AS 'sales'FROM  sales_records  WHERE `when` BETWEEN '2011-09-01 00:00:00' AND '2012-02-29 23:59:59'GROUP BY `from`,  MONTH(`when`),  YEAR(`when`) WITH ROLLUP;