Cacher is the code snippet organizer for pro developers

SELECT sub_query.month_ordered,
       sub_query.year_ordered,
       SUM(sub_query.base_subtotal) AS sum_base_subtotal,
       SUM(sub_query.discount_amount) AS sum_discount_amt,
       SUM(sub_query.order_qty) AS sum_total_item_count,
       COUNT(sub_query.entity_id) AS total_orders
FROM
  (SELECT so.entity_id,
          MONTH(so.created_at) AS month_ordered,
          YEAR(so.created_at) AS year_ordered,
          so.base_subtotal,
          so.discount_amount,
          so.total_item_count AS order_qty,
          so.increment_id
   FROM `sales_flat_order` AS so
   INNER JOIN `sales_flat_order_item` AS si ON si.order_id=so.entity_id
   GROUP BY entity_id) AS sub_query
GROUP BY sub_query.month_ordered
ORDER BY year_ordered DESC,
         month_ordered DESC