mttjohnson · April 22, 2021 22:17
diff --git a/magento2_order_by_date_hour.sql b/magento2_order_by_date_hour.sql
 -- Magento 2 Order Summary by date/hour

 select date_format( created_at, '%Y-%m-%d %H:00' ) date_hour, 
 	count(*) order_count
 from sales_order o
 where o.created_at > '2021-01-01' and o.created_at < '2021-04-10'
 group by date_format( created_at, '%Y%m%d%H' )
 having order_count > 100
 order by order_count desc;
	-- Magento 2 Order Summary by date/hour

	select date_format( created_at, '%Y-%m-%d %H:00' ) date_hour,
	count(*) order_count
	from sales_order o
	where o.created_at > '2021-01-01' and o.created_at < '2021-04-10'
	group by date_format( created_at, '%Y%m%d%H' )
	having order_count > 100
	order by order_count desc;