-- 44、检索至少选修两门课程的学生学号

科技2025-04-18 7

SELECT st.s_id FROM student st LEFT JOIN score sc ON sc.s_id=st.s_id GROUP BY st.s_id HAVING COUNT(1)>=2

Processed: 0.014, SQL: 8