select sum(cnt) 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 cnt from cultivate_tb )a