查询任何一门课程成绩在70分以上的姓名、课程名称和分数

SELECT distinct student.S#,student.Sname,SC.C#,SC.score FROM student,Sc WHERE SC.score>=70 AND SC.S#=student.S#;