SELECT `from`,SUM(IF(split_comp,0.5,1)) AS 'Total Sales',SUM(IF(split_comp,0.5,1))/COUNT(DISTINCT MONTHNAME(`when`)) AS 'AVG',COUNT(DISTINCT MONTHNAME(`when`)) AS 'Months used',SUM( IF(MONTH(`when`) = 2,SUM(IF(split_comp,0.5,1)),0))
FROM sales_records
JOIN users ON users.username = sales_records.from
WHERE users.inactive=FALSE AND users.type='agent' AND `when` BETWEEN '2010-12-01 00:00:00' AND '2011-01-31 23:59:59'
GROUP BY `from`
ORDER BY `from` ASC;