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%'
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%'