select * from Teaches  as a 
where  exists(select 1 from course  
  where course_id like 'CS-1%' and course_id=a.course_id
)

------解决方案--------------------

SQL code
select
  *
from
  teaches
where 
  course_id in(select course_id from course  where course_id like 'CS-1%')