我想算一下分散但合并在一起的员工的出勤率

我的目标输出

我的密码

 SELECT count(employees_id) as numbers FROM attendance WHERE in_time != ' ' AND out_time != ' 'AND employees_id = 1
 SELECT count(employees_id) as numbers FROM attendance WHERE in_time != ' ' AND out_time != ' 'AND employees_id = 260

需要帮助将他们分开谢谢:)

分析解答

您可以在下面尝试-将group by与employee_id结合使用

SELECT employees_id,count(*) as numbers 
FROM attendance WHERE in_time != ' ' AND out_time != ' '
group by employees_id