文件名称：Oracle练习题
文件大小：53KB
文件格式：DOCX
更新时间：2022-03-04 04:17:40
oracle
1、查询“001”课程比“002”课程成绩高的所有学生的学号 1. select a.S# from (select S#,score from SC where C#='001')a, 2. (select s#,score from SC where c#='002')b Where a.score>b.score and a.s# = b.s#; 3. 2、查询平均成绩大于60分的同学的学号和平均成绩 select S#, avg(score) from sc group by S# having avg(score)>60 3、查询所有同学的学号、姓名、选课数、总成绩 1. select student.S_id, student.Sname, count(sc.C_id), sum(score) from student 2. left join SC on student.S_id = SC.S_id group by Student.S_id, Sname