查询人脸机分配名单数量

select clock_id as 机号,COUNT(card_id)as 人数 from AssignEmpOther where photo_downstate=4 group by clock_id