mattyx17

看来你应该用月而不是日,而且一个月又一个月都没有括号

SELECT COUNT(DISTINCT department_id) AS departments,
       COUNT(*) AS employees
FROM department
WHERE date_time>=DATE_FORMAT(NOW() ,'%Y-%m-01')
AND date_time < DATE(NOW()+INTERVAL 1 MONTH)
AND status = '1';