Nice monthly breakdown SQL

middleware-year-monthly-breakdown.sql

/*
 * Uses MySQL SQL Syntax
 */
SELECT 
	YEAR(O.`when`) as `year`,
    MONTH(O.`when`) as `month`,
    COUNT(O.id) as `Orders Passed`, CONCAT('$',(COUNT(O.id) * 2)) as `earned`
FROM middleware.order_link O
    GROUP BY `year`, `month`
UNION
SELECT 
	NULL as `year`,
	NULL as `month`,
	COUNT(O.id) as `Orders Passed`,
	CONCAT('$',(COUNT(O.id) * 2)) as `earned`
FROM middleware.order_link O