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

with a as(
select *
,case when course like '%1%' then 1 else 0 end as course1
,case when course like '%2%' then 1 else 0 end as course2
,case when course like '%3%' then 1 else 0 end as course3
from cultivate_tb
)

select (sum(course1)+sum(course2)+sum(course3)) as staff_nums
from a