A SQL Written exam question: Use standard SQL nested statements to query the names and units of the students taking all courses

S (Sno,sname,sdd,sage)

Sno,sname,sdd,sage

Each representative of the school number, learning

Member's name, affiliation, student's age

C (Cno,cname)

Cno,cname

Represent the course number, the course name, respectively

SC (Sno,cno,score)

Sno,cno,score

Representing the school number,

of the Elective

Course number, learning score

The data for the three tables are as follows:

Problem:

Use standard SQL nested statements to query the name and affiliation of the student taking all courses

Write your own sql:

SELECT SNO,SDD from S WHERE SNO in
(
Select Sno from
(
SELECT Sno,count (SC.CNO) as COUNTC from SC right JOIN C on SC. Cno=c.cno
GROUP by SNO have COUNT (sc.cno) = (select COUNT (distinct c.cno) from c)
) A
);

A SQL Written exam question: Use standard SQL nested statements to query the names and units of the students taking all courses