- 查询课程名称为「数学」,且分数低于 60 的学生姓名和分数
SELECT Student.Sname,Course.Cname,SC.score FROM Student,Course,SC WHERE
Student.SId = SC.SId AND Course.CId = sc.cid AND Course.Cname='数学'AND sc.score <60
2024-03-26 23:27:46
SELECT Student.Sname,Course.Cname,SC.score FROM Student,Course,SC WHERE
Student.SId = SC.SId AND Course.CId = sc.cid AND Course.Cname='数学'AND sc.score <60