查询计算机系选修了三门以上课程的学生学号、姓名。的完整代码

SELECT sno, sname
FROM student
WHERE dept = '计算机系' AND sno IN (
    SELECT sno
    FROM sc
    GROUP BY sno
    HAVING COUNT(DISTINCT cno) >= 3
);