题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
select ct.staff_id, staff_name from cultivate_tb ct join staff_tb st on ct.staff_id = st.staff_id where substring_index(course,',',-1) = 'course3' order by ct.staff_id asc
查看2道真题和解析