[Magento SQL] 获取订单 总金额，总Qty，并排除 指定客户Email的订单

SELECT main_table.increment_id, main_table.created_at,main_table.base_grand_total,
                main_table.`status`,customer_table.email,SUM(qty_ordered) AS total_qty_ordered
                FROM sales_flat_order_grid AS main_table
                LEFT JOIN customer_entity AS customer_table ON main_table.customer_id = customer_table.entity_id
                LEFT JOIN sales_flat_order_item AS item_table ON item_table.order_id= main_table.entity_id
                WHERE item_table.product_type='simple'
                AND main_table.created_at >= '{$created_at}'
                AND main_table.created_at < DATE_ADD('{$created_at}',interval 1 day)
                AND (main_table.status = 'processing' OR main_table.status = 'complete')
                AND customer_table.email NOT IN ('rr@gmail.com','88@gmail.com') 
                GROUP BY main_table.increment_id