数据统计问题，求指点

SQL code

数据：ID      PID     UserID Type          Time714    1276    2771    2    2012-04-14 13:15:02.427714    1340    2771    2    2012-04-14 13:15:02.427714    1525    2771    2    2012-04-14 13:15:02.427714    12011    2771    2    2012-06-14 18:15:09.223714    12194    2771    2    2012-06-21 14:00:00.000723    12599    2771    1    2012-07-04 14:00:00.000723    1289    2771    1    2012-04-14 13:15:02.427723    2138    2771    1    2012-04-14 13:15:02.427724    1867    2771    1    2012-04-14 13:15:02.427724    1928    2771    1    2012-04-14 13:15:02.427724    1290    2771    1    2012-04-14 13:15:02.427724    1292    2771    1    2012-04-14 13:15:02.427724    1323    2771    1    2012-04-14 13:15:02.427724    12233    2771    1    2012-06-22 11:00:00.000724    12497    2771    1    2012-07-02 14:00:00.000724    12207    2771    1    2012-06-21 11:00:00.000743    12775    2771    1    2012-07-11 11:00:00.000743    1317    2771    1    2012-04-14 13:15:02.427743    1531    2771    1    2012-04-14 13:15:02.427743    1858    2771    1    2012-04-14 13:15:02.427743    1958    2771    1    2012-04-14 13:15:02.427813    2036    2771    1    2012-04-14 13:15:02.427813    2135    2771    1    2012-04-14 13:15:02.427

一名语句，统计出Type为1与2各自的count数，当ID一样时，计为1，请大牛指点，非常感谢

[解决办法]

SQL code

SELECT    TYPE,COUNT(DISTINCT ID) AS CNTFROM  TBGROUP BY TYPE