select * from course where
EXISTS (SELECT courseId from score GROUP BY courseId HAVING
avg(result)>95)
AND
id in (select courseId from score GROUP BY courseId HAVING avg
(result)>75)
;
MYsql查询语句
最新推荐文章于 2024-08-06 21:36:57 发布
select * from course where
EXISTS (SELECT courseId from score GROUP BY courseId HAVING
avg(result)>95)
AND
id in (select courseId from score GROUP BY courseId HAVING avg
(result)>75)
;