题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
with
t1 as(
select
staff_id,
staff_name
from
staff_tb left join cultivate_tb using(staff_id)
where
course like '%course3%'
order by
staff_id
)
select * from t1
