Average Sales Excluding Shipping, Tax, Discounts

average-sales-excluding-shipping-tax-discounts.sql

SELECT 
	date_format(date_sub(created_at, INTERVAL 5 HOUR), "%Y-%m-%d") AS `Day`
	, count(*) as `Count`
	, AVG(grand_total - tax_amount - shipping_amount) AS `Avg Sales Excluding Tax/Shipping/Discounts`
	, AVG(discount_amount) `Avg Discount`
	, AVG(tax_amount) `Avg Tax`
	, AVG(shipping_amount) `Avg Shipping`
FROM sales_flat_order
WHERE created_at BETWEEN '2014-04-01 05:00:00' AND '2014-04-30 05:00:00'
GROUP BY date_format(date_sub(created_at, INTERVAL 5 HOUR), "%Y-%m-%d")
ORDER BY date_format(date_sub(created_at, INTERVAL 5 HOUR), "%Y-%m-%d") DESC