帮帮初学者吧！

[apooo]

这样的sql语言如何写啊？

考勤系统中有每个员工的每天的考勤纪录。
表：table_work
字段：userid,workdate,status
（status 为“2” 表示迟到）

要统计每个员工的迟到次数，降序排列如下：

员工 迟到次数
...........................
王 5
张 4
赵 2
...........................

[dulei115]

select workdate as 员工,count(userid) as 迟到次数
from table_work
group by workdate

[dulei115]

select workdate as 员工, as 迟到次数
from table_work
group by workdate
order by count(userid) desc

[kmhertz]

select userid,sum(status) as 迟到次数 from table_work group by userid order by a desc

[icedut]

select workdate as 员工,count(userid) as 迟到次数
from table_work where status ='2'
group by workdate
order by count(userid) desc

[dulei115]

select workdate as 员工, count(userid) as 迟到次数
from table_work
where status = 2
group by workdate
order by count(userid) desc

[icedut]

select userid as 员工,count(userid) as 迟到次数
from table_work where status ='2'
group by userid
order by count(userid) desc

[apooo]

感谢各位老大！