说明: 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
<qq_33207296> 上传 | 大小:53kb