Task: Text to Code
Input (English): Step 1: find the semester_name of Semesters table.
Step 2: find the course_name of Courses table whose course_name not one of the results of step 1
Output (English): SELECT T1.course_name FROM Courses AS T1 WHERE T1.course_name NOT IN ( SELECT T2.semester_name FROM Semesters AS T2 )