Magento获取 最近一个月产品销量，按照SKU分组 的SQL语句。

SELECT created_at,sku,name, SUM(qty_ordered) AS total_ordered
FROM sales_flat_order_item
WHERE created_at >= DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY sku order by total_ordered desc