How many students are not enrolled in the course?
select count ( * ) from student where stuid not in ( select stuid from enrolled_in )
Just the first names
select fname from student where stuid in ( select stuid from enrolled_in )