SELECT st.sid,st.sname,avg(s.score) from student st INNER join sc s on st.sid = s.sid where s.sid in(
SELECT s1.sid from sc s1 where s1.score<60 group by s1.sid having count(1)>=2) group by s.sid;
网上关于这题,大多数的解答都有问题。在此提醒一下自己。
SELECT st.sid,st.sname,avg(s.score) from student st INNER join sc s on st.sid = s.sid where s.sid in(
SELECT s1.sid from sc s1 where s1.score<60 group by s1.sid having count(1)>=2) group by s.sid;
网上关于这题,大多数的解答都有问题。在此提醒一下自己。
转载于:https://www.cnblogs.com/wylwyl/p/10626107.html