SQL & PL/SQL

Hi Experts,

I would like to retrieve count of the values separated by comma using regexp_substr but i get more values than expected

COUNT(*)  TAGS

           1     MCS, MAX, MOB

           1     MCS

           1     Web, Multi, Workshop

           2     Web

select distinct count(*), taggs from (select regexp_substr(tags,'[^,]+', 1, level )taggs from XXRequests

connect by regexp_substr(tags, '[^,]+', 1, level) is not null) group by taggs;

This is happening since i receive more rows in single select. Can you please let me know how to correct this.

Thanks,

Vinodh