Query only branch grade of the highest student information,
Query computer science student elective courses of the highest and lowest points, total score, the column for the corresponding Chinese characters,
Student (Sno Sname Ssex Sage Sdep)
Course (Cno Cname the Teacher)
SC (Sno Cno Grade)

CodePudding user response:

 
-- the only branch top student information, 
The select a.C no, a.C name, c.s. no, c.s. name, b.G rade 
The from Course a 
Inner join SC b on a.C no=biggest no 
Inner join (select Cno, Grade=Max (Grade) 
The from SC 
Group by Cno) m on biggest no=m.C no 
And b.G rade=m.G rade 
Inner join Student c on c.s. no b.S no=