题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
#find_in_set可用来判断模拟数据中是否包含某个元素
select
c.staff_id,
staff_name
from cultivate_tb c left join staff_tb s on c.staff_id = s.staff_id
where find_in_set('course3',course)>0
order by c.staff_id
