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

WITH t1 AS (
    SELECT CASE 
              WHEN course IS NULL THEN 0
              ELSE LENGTH(course)-LENGTH(REPLACE(course,',',''))+1
              END AS nums 
    FROM cultivate_tb
)
SELECT sum(nums) AS staff_nums
FROM t1