题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
select s.staff_id,staff_name from staff_tb s join cultivate_tb c on c.staff_id=s.staff_id where course like "%3%" --course like "%3%" 是模糊匹配包含数字 3 的任意内容 order by s.staff_id