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

SELECT
    SUM(
        CASE
            WHEN length(course) = 7 THEN 1
            WHEN length(course) = 15 THEN 2
            WHEN length(course) = 23 THEN 3
            ELSE 0
            END ) AS staff_nums
FROM cultivate_tb