有关骑手跑单分段统计

最新推荐文章于 2025-04-28 19:31:40 发布

TracyLi2019

最新推荐文章于 2025-04-28 19:31:40 发布

阅读量379

点赞数 6

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/TracyLi2019/article/details/146361509

版权

MYSQL 骑手跑单分段统计

需求统计24年各月，在固定配送团队的，不同订单距离的骑手跑单量
*根据月份和骑手id作为分类

SELECT 
    YEAR(date)  AS 年份,
	MONTH(date) AS 月份,
	team_name AS   配送团队,	
	rider_id  AS    骑手id,
	rider_name   AS   骑手姓名  ,
	SUM(IF(distribution_status='配送成功', 1, NULL))  AS  累计完成单量,
	COUNT(CASE WHEN distribution_distance >= 3 AND distribution_distance < 4 THEN 1 END) AS `包含3公里到4公里`,
    COUNT(CASE WHEN distribution_distance >= 4 AND distribution_distance < 5 THEN 1 END) AS `包含4公里到5公里`,
    COUNT(CASE WHEN distribution_distance >= 5  THEN 1 END) AS `>=5公里`
FROM rider_info
WHERE team_name = '飞毛腿团队' AND date BETWEEN '2024-01-01' AND  '2024-12-31'
GROUP BY   MONTH(date) , rider_id
ORDER BY   MONTH(date) , rider_id