kolaente · February 12, 2020 09:54
diff --git a/magento_orders.sql b/magento_orders.sql
 select ROUND(SUM(base_grand_total), 2) total,
       ROUND(AVG(base_grand_total), 2) average,
       count(*),
       DATE(created_at)                dt
 from sales_order
 where created_at > '2020-01-01 00:00:00'
 GROUP BY dt
 order by dt;
	select ROUND(SUM(base_grand_total), 2) total,
	ROUND(AVG(base_grand_total), 2) average,
	count(*),
	DATE(created_at) dt
	from sales_order
	where created_at > '2020-01-01 00:00:00'
	GROUP BY dt
	order by dt;