-- 44、检索至少选修两门课程的学生学号(不重要)
SELECT s_id,COUNT(DISTINCT c_id) FROM score
GROUP BY s_id HAVING COUNT(DISTINCT c_id)>=2
44、检索至少选修两门课程的学生学号(不重要)(自己做出)
最新推荐文章于 2023-08-22 16:03:35 发布
-- 44、检索至少选修两门课程的学生学号(不重要)
SELECT s_id,COUNT(DISTINCT c_id) FROM score
GROUP BY s_id HAVING COUNT(DISTINCT c_id)>=2