求SQL语句问题
Table admin
adminID adminName admintype
1 xiaoming 3
2 xiaohua 2
3 xiaowang 2
4 yu 1
5 lai 4
Table userType
TypeIDTypeName
1Student
2Teacher
3Cleaner
4Manager
5Counselor
按userType列出TypeID，TypeName和UserCount（用户数量），如果这个Type下没有用户，则显示0，按UserCount降序排序，然后在按TypeName升序排序。
请问怎么求啊
[解决办法]
select TypeID,
TypeName,
UserCount = ISNULL((SELECT COUNT(1)
FROM [admin]
WHERE [admin].admintype = [userType].TypeID),0)
FROM [userType]
ORDER BY
ISNULL((SELECT COUNT(1)
FROM [admin]
WHERE [admin].admintype = [userType].TypeID),0) DESC
