有三个表S(学号s#,姓名sname,。。。)、C(课程号c#,课程名cname,。。。)、SC(学号s#,课程号c#,成绩grade。。。) select sname,avg(grade) from s,sc where s.s#=sc.s# and grade<60 group by sname having by count(grade)>=2
有三个表S(学号s#,姓名sname,。。。)、C(课程号c#,课程名cname,。。。)、SC(学号s#,课程号c#,成绩grade。。。)select sname,avg(grade)from s,sc where s.s#=sc.s# and grade&lt;60group by snamehaving by count(grade)&gt;=2...