求一关于统计我SQL语句

Question

ID No UserID Time
1 J 1 2008-9-8 22:02
2 H 3 2008-9-9 16:34
3 J 3 2008-9-9 16:35
4 H 5 2008-9-9 17:05
20 J 11 2008-9-10 11:46
21 P 4 2008-9-10 11:47
22 J 11 2008-9-10 11:48
23 H 11 2008-9-10 11:49
5 J 3 2008-10-9 17:30
6 M 3 2008-10-10 9:17
7 J 5 2008-10-10 9:28
8 H 5 2008-10-11 9:28
9 D 3 2008-10-12 9:28
10 H 10 2008-10-13 9:28
11 J 4 2008-10-14 9:28
12 K 4 2008-11-10 10:15
13 J 3 2008-11-11 10:15
14 T 3 2008-11-12 10:15
15 O 3 2008-11-13 10:15
16 A 11 2008-11-14 10:15
17 J 11 2008-11-15 10:15
18 H 3 2008-11-16 10:15
19 J 11 2008-11-17 10:15
按月统计出第三列中不同无素对应第二例的个数(如9月1对应的结果为1,9月3对应的结果为2,即为: 9月  1   1
                                                                             9月  3   2
                                                                              .   .  .
                                                                             10月  3   3
                                                                             .     .   .

Answer 1

select convert(varchar(6),time,112),useID,count(NO)
from ---
group by convert(varchar(6),time,112),useID

Answer 2

ID        No        UserID        Time
1        J        1        2008-9-8 22:02
2        H        3        2008-9-9 16:34
3        J        3        2008-9-9 16:35
4        H        5        2008-9-9 17:05
20        J        11        2008-9-10 11:46
21        P        4        2008-9-10 11:47
22        J        11        2008-9-10 11:48
23        H        11        2008-9-10 11:49
5        J        3        2008-10-9 17:30
6        M        3        2008-10-10 9:17
7        J        5        2008-10-10 9:28
8        H        5        2008-10-11 9:28
9        D        3        2008-10-12 9:28
10        H        10        2008-10-13 9:28
11        J        4        2008-10-14 9:28
12        K        4        2008-11-10 10:15
13        J        3        2008-11-11 10:15
14        T        3        2008-11-12 10:15
15        O        3        2008-11-13 10:15
16        A        11        2008-11-14 10:15
17        J        11        2008-11-15 10:15
18        H        3        2008-11-16 10:15
19        J        11        2008-11-17 10:15
按月统计出UserID里每个用户对应No列的记录个数(也可以理解成按月统计出UserID里每个用户的个数,因为在数值上他们是相等的)
一楼 不能比较或排序 text、ntext 和 image 数据类型，除非使用 IS NULL 或 LIKE 运算符。

Answer 3

SELECT  COUNT(1) AS [count],
        USERID,
        DATEPART(M, [DATETIME]) AS MONTH
FROM    tb
GROUP BY USERID,
        DATEPART(M, [DATETIME])

Answer 4

使用函数datepart()会好看一点。select datepart(mm,Time),userid as,count(userid) 
from t 
group by datepart(),userid