题解 | #统计所有课程参加培训人次#
统计所有课程参加培训人次
https://www.nowcoder.com/practice/98aad5807cf34a3b960cc8a70ce03f53
select sum(cast(course_number as unsigned)) as staff_nums from (select CASE WHEN course like 'course_,course_,course_' THEN '3' WHEN course like 'course_,course_' THEN '2' WHEN course like 'course_' THEN '1' ELSE null end as course_number from cultivate_tb ) as a 可是示例中也没有staff_nums啊 给的不是course_pv吗 sd平台
