how many students have not enrolled in any courses
select count ( * ) from student where stuid not in ( select stuid from enrolled_in )
i need the students first name
select fname from student where stuid not in ( select stuid from enrolled_in )
list the first name and last name of students with grade A
select t1.fname, t1.lname from student as t1 join enrolled_in as t2 on t1.stuid = t2.stuid where t2.grade = "A"
WHAT IS THE ID OF THESE STUDENTS
select stuid from enrolled_in where grade = "A"