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


京公网安备 11010502036488号