What are the student ids for each student?
select stuid from student
Of those, which are not enrolled in any courses?
select stuid from student where stuid not in (select stuid from enrolled_in)
What are their first names?
select fname from student where stuid not in (select stuid from enrolled_in)