我需要计算一个月内不同部门的员工总数,但不幸的是查询不起作用并抛出错误
Department_id emloyee_id date_time
1 1 2020-02-01
1 2 2020-02-04
3 7 2020-02-06
1 4 2020-02-07
预期产量
total department=2
total employee of all department=4
但所有这些都应该基于最后一条记录,我得到了sql语法错误
查询:
SELECT COUNT(DISTINCT department_id) x, COUNT(*) y
FROM department
WHERE date_time>=DATE_FORMAT(NOW() ,'%Y-%m-01')
AND date_time<DATE(NOW()+INTERVAL 1 DAY and status='1'
