SELECT Name FROM teacher WHERE Teacher_id NOT IN (SELECT Teacher_id FROM course_arrange)
List the names of teachers who have not been arranged to teach courses.
SELECT Name FROM teacher WHERE Teacher_id NOT IN ( SELECT Teacher_id FROM course_arrange )
select name from teacher where teacher_id not in ( select teacher_id from course_arrange )
List the names of teachers who have not been arranged to teach courses .