题解 | 统计所有课程参加培训人次

with
t1 as(
    select
        case
            when course is null then 0
            else length(course) - length(replace(course,',',''))+1
        end as staff_nums
    from
        cultivate_tb
)

select sum(staff_nums) as staff_nums from t1