To retrieve the names of students not enrolled in C06 and their classes

2. Suppose that three relationships have been established in the teaching database:
student(sno, sname, sex, birth, height, class, address)
course(cno, cname, elective Relational elective(sno, cno, grade)
Elective Relational Algebra and SQL language to put the following query respectively:

To retrieve the names and classes of students who did not take C06.
SELECT SNAME,CALSS FROM S WHERE SNO NOT IN(SELECT SNO FROM SC WHERE CNO='C06 ')

Select sname, calss from s where sno not in(select sno from sc where cno =' c06 ')

Good Question 0Comment Collection Report

0 Answer

dengwenlon 注册会员
2023-02-28 00:31

This answer quotes ChatGPT

Your query statement is incorrect. The correct SQL query statement is

SELECT student.sname, student.class
FROM student
WHERE student.sno NOT IN (
    SELECT elective.sno
    FROM elective
    WHERE elective.cno = 'C06'
);

This query uses a subquery to find the number of a student taking course C06 on elective relational table Elective table, and then finds a student name and class that does not appear in this subquery result in Student relational table Student.

Agree 0 0Comment

About the Author

: GDL5211dht 注册会员
这家伙很懒，什么都没留下...

0: Answer

0: Article

0: Question

Question Info

Publish Time: 2023-02-28 00:31

Update Time: 2023-02-28 00:31