select sum(num) as staff_nums
from
(
select 
case
when length(course) = 7 then 1
when length(course) = 15 then 2
when length(course) = 23 then 3
else 0
end as num
from cultivate_tb
) as t1