-- 34、查询课程名称为“数学“，且分数低于60的学生姓名和分数

科技2023-12-24 98

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.s_score<60 INNER JOIN course c ON c.c_id=sc.c_id AND c.c_name ="数学"

Processed: 0.015, SQL: 8