Table S: (SNO, SNAME) students table, SNO as student id, SNAME name;
Table C: (CNO, CNAME, CTEACHER) curriculum, CNO for the course number, CNAME for course name, CTEACHER for classroom teachers;
Table SC: (SNO, CNO, SCGRADE) course selection table, SNO as student id, CNO for the course number, SCGRADE for scores,
Class grades listed the "001", "002" class result high score all the student's student id number and "001" number and the number "002" course grades

CodePudding user response:

How do I write but only look up to the student number Select * from sc. A, sc. B where a.s no=b.s no, a and a.s no='001' and b.s no - '002' and a.s cgrade> B.s cgrade; After don't know how to write