题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
SELECT
`staff_tb`.`staff_id`,
`staff_name`
FROM `staff_tb`
JOIN `cultivate_tb` oN `staff_tb`.`staff_id`=`cultivate_tb`.`staff_id`
WHERE `course` LIKE '%3'
ORDER BY `staff_tb`.`staff_id`;
