SQL 计算营业时间为上午 10 点到早上 6 点的客户的不同访问次数

# 分析上午10点到早上6点的客户访问次数

sql
SELECT *
FROM customer_visits
WHERE TIME_FORMAT(visit_time, '%H:%i') BETWEEN '10:00' AND '06:00';

sql
SELECT customer_id, COUNT(*) AS visit_count
FROM customer_visits
WHERE TIME_FORMAT(visit_time, '%H:%i') BETWEEN '10:00' AND '06:00'
GROUP BY customer_id;