presto将字段分割，统计分割之后的数量

如有个字段叫a，里面都是字符串  1_2_3;3_4_5

需要分割之后统计每个部分的次数

select split_part,count(1) as cnt 
from 
(
select regexp_extract_all(exp_ids, '[^_]+') as split_parts
from (
select   exp_ids,
        column 
from    xxx

)t1 
)t2
CROSS JOIN UNNEST(split_parts) AS u(split_part)
GROUP BY split_part