统计业务人员用车数量

SELECT customer_name,

       GROUP_CONCAT(situation SEPARATOR '\n') AS all_situations

FROM oa_work_log

WHERE create_by = '8503f1404da9-11e8-ba0d-ab89f4859f5f'

  AND work_date BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY customer_name;SELECT

    p.work_date,

    o.name AS office_name,

    u.name AS create_name,

    SUM(p.use_car) AS total_use_car  -- 计算用车记录的总和

FROM

    oa_work_log p

JOIN

    sys_office o ON p.office_id = o.id

JOIN

    sys_user u ON p.create_by = u.id

WHERE

    p.del_flag = 0

    AND o.del_flag = 0

    AND p.office_id IN (49, 51, 52, 53, 54, 73)

    AND p.work_date BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY

    p.work_date, o.name, u.name  -- 按工作日期和办公室名称以及创建者分组

ORDER BY

    p.office_id,  -- 按照 office_id 排序

    p.work_date ASC;  -- 其次按 work_date 正序排列