también los puedes sacar,
Código sql:
Ver originalSELECT orders.cantidad,orders.order_date,orders.mesInicio,SUM(orders.cantidad)AS tope FROM (
SELECT COUNT(order_id)AS cantidad, order_date, MONTH(order_date)AS mes,
MONTH(date_sub( CURDATE( ) , INTERVAL 11 MONTH )) AS mesInicio
FROM orders
WHERE order_date>=date_sub(CURDATE(),INTERVAL 12 MONTH)
GROUP BY MONTH(order_date)
ORDER BY order_date ASC
)orders GROUP BY orders.campo_que_quieras.