查询设备机号、名单

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