请教一个SQL统计问题

[powbcom]

表Cate(sort 是排升序)
CateName sort
家私 1
装饰 2
购物 3

表Member
User CateName
a 家私
b 装饰
c 装饰

如何用Sql语句列出cate表的数据并统计catename在表memeber中的数量,结果应该是:
CateName sort count
家私 1 1
装饰 2 2
购物 3 0

[itblog]

select catename,sort,[count]=(select count(1) from Member where CateName=a.Catename) from Cate a

[paoluo]

Select
A.CateName,
A.sort,
IsNull(Count(B.[User]),0) As [count]
From
Cate A
Inner Join Member B
On A.CateName=B.CateName
Group By A.CateName,A.sort

[itblog]

select * from Cate a,(select Catename,[count]=count(puser]) from Member group by Catename) b where a.CateName=b.CateName

[Sunyo00]

select a.CateName,a.sort,count(b.CateName) as count
from Cate a left join Member b
on a.CateName = b.CateName
group by a.CateName,a.sort