题解 | #查询培训指定课程的员工信息#

with department_cul as (
    select a.staff_id,
           staff_name,
           course
    from staff_tb a 
    right join cultivate_tb b on a.staff_id=b.staff_id
)

select staff_id,staff_name
from department_cul
where course like '%course3%'