mysql查询a表字段在b表中出现的次数，并排序

[qq_37177734]

打个比方user是用户表，msg是信息表
user
id name
1 a
2 b

msg
id uid content
1 1 qq
2 1 ss
3 2 dd

现在我要查询所有用户信息以及他们的发言数量，并能按统计数量进行排序，也就是下面这种结果集；该怎么写语句呢
id name count
1 a 2
2 b 1

[zanglengyu]

SELECT m.uid as id ,u.name,count(m.uid) from `user` u , msg m WHERE u.id=m.uid group by uid

[密码测试]

select t.id id, t.name name, count(m.content) cnt from user t, msg m where t.id = m.uid group by t.id order by cnt;