求一SQL统计语句。。。。。。
简化的数据样本内容如下:
RepID InputDate
8389 2004-06-03 16:42:37.000
8388 2004-06-03 15:32:17.000
8387 2004-06-03 15:27:57.000
8386 2004-06-03 15:22:26.000
8385 2004-06-03 15:21:20.000
8384 2004-06-03 15:19:22.000
8271 2004-06-02 09:39:14.000
8270 2004-06-02 09:24:18.000
8269 2004-06-02 09:18:56.000
8268 2004-06-02 09:16:04.000
8240 2004-06-01 14:38:35.000
8239 2004-06-01 14:37:53.000
8238 2004-06-01 14:14:16.000
8237 2004-06-01 14:04:12.000
8236 2004-06-01 14:01:37.000
8234 2004-06-01 13:59:15.000
8233 2004-06-01 13:55:05.000
要求统计指定月份每一天RepID的数量,查询结果类似下面:
InputDate Amount
2004-06-01 7
2004-06-02 4
2004-06-03 6
......
谢谢!