-- 38、查询课程编号为01且课程成绩在80分以上的学生的学号和姓名

科技2023-12-23 104

SELECT st.s_id,st.s_name,sc.s_score FROM student st INNER JOIN score sc ON sc.s_id=st.s_id AND sc.c_id="01" AND sc.s_score>=80

Processed: 0.029, SQL: 8