willboudle · January 7, 2018 12:49
diff --git a/avgorderperday.sql b/avgorderperday.sql
 SELECT AVG( orders_num )
 FROM (
 SELECT created_at, COUNT( DISTINCT order_id ) orders_num
 FROM `sales_flat_order_item`
 WHERE created_at  > "2016-07-01 00:00:00"
 AND created_at  < "2017-01-01 00:00:00"
 GROUP BY CAST( created_at AS DATE )
 )orders_per_day
	SELECT AVG( orders_num )
	FROM (
	SELECT created_at, COUNT( DISTINCT order_id ) orders_num
	FROM `sales_flat_order_item`
	WHERE created_at > "2016-07-01 00:00:00"
	AND created_at < "2017-01-01 00:00:00"
	GROUP BY CAST( created_at AS DATE )
	)orders_per_day
No results found