SELECT DATE(order_date) AS order_day, HOUR(order_date) AS order_hour, COUNT(*) AS order_count
FROM orders
WHERE order_date >= '开始时间' AND order_date <= '结束时间'
GROUP BY order_day, order_hour;
10-16
2915
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交