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
    )
  ) 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;