select distinct REGEXP_SUBSTR(SUBMIT_PERSION_ORG_ID,'[^,]+',1,1 ) orgId, REGEXP_SUBSTR(SUBMIT_PERSION_ORG_NAME,'[^,]+',1,1 ) orgName, sum(count(*)) over (partition by REGEXP_SUBSTR(SUBMIT_PERSION_ORG_ID,'[^,]+',1,1 ) ) from BUSI_INFO where 1=1 AND BUSI_STAGE >='2' group by SUBMIT_PERSION_ORG_ID,SUBMIT_PERSION_ORG_NAME
REGEXP_SUBSTR(SUBMIT_PERSION_ORG_ID,'[^,]+',1,1 )