56,914
社区成员




SELECT
udate.RepDate,
IFNULL(ct.ctCount,0),
IFNULL(tk.tkCount,0)
FROM u_date AS udate
LEFT JOIN (
SELECT
DATE(task.CREATE_TIME) AS dt,
COUNT(0) AS ctCount
FROM e_escort_task AS task
GROUP BY dt
) AS ct ON udate.RepDate = ct.dt
LEFT JOIN (
SELECT
DATE(task.TASK_TIME) AS dt,
COUNT(0) AS tkCount
FROM e_escort_task AS task
GROUP BY dt
) AS tk ON udate.RepDate = tk.dt
WHERE udate.RepYear = 2018 AND udate.RepMonth = 9