#查询Score表中至少有5名学生选修的并以3开头的课程的平均分数 SELECT AVGdegree FROM score WHERE ORDER BY COUNT1 = 5 HAVING cno LIKE 3;
SELECT AVG(degree) FROM score WHERE cno LIKE '3%' GROUP BY cno HAVING COUNT(DISTINCT sno) >= 5;
原文地址: https://www.cveoy.top/t/topic/iAXN 著作权归作者所有。请勿转载和采集!