Which semesters do not have any student enrolled? List the semester name.
create table student_enrolment (semester_name varchar, semester_id varchar, PRIMARY KEY (semester_name)); create table semesters (semester_name varchar, semester_id varchar, PRIMARY KEY (semester_name))
select semester_name from semesters where not semester_id in (select semester_id from student_enrolment)