题解 | 统计所有课程参加培训人次
统计所有课程参加培训人次
https://www.nowcoder.com/practice/98aad5807cf34a3b960cc8a70ce03f53
WITH count_tb AS (
SELECT staff_id,
CASE WHEN course LIKE '%,%,%' THEN 3
WHEN course LIKE '%,%' THEN 2
WHEN course IS NULL THEN 0
ELSE 1 END AS course_count
FROM cultivate_tb
)
SELECT SUM(course_count) as staff_nums
FROM count_tb
