select sum(case when course is null then 0 
         else 
          length(course) - length(replace(course,',','')) +1
          end) as staff_nums
from cultivate_tb

统计课程数, 计算非空情况的“,”个数,用字符串长度减去去掉“,”之后的字符串长度