zapytanie po dacie

select COUNT(*), MONTH(created_at) FROM `order` WHERE 
created_at >= '2021-01-01 00:00:00'
AND created_at <= '2021-11-01 00:00:00'
GROUP BY YEAR(created_at), MONTH(created_at)

select COUNT(*) FROM `order` WHERE created_at >= '2021-01-01 00:00:00' AND created_at <= '2021-11-01 00:00:00'