17,092
社区成员
发帖
与我相关
我的任务
分享
SELECT S.SN, AVG(SC.SCORE)
FROM S, SC
WHERE S.SID IN
(
SELECT SC.SID FROM SC
WHERE SC.SCORE < 60
GROUP BY SC.SID
HAVING COUNT(SC.CID) >= 2
)
where s.sid=sc.sid
GROUP BY s.sn