select s.学号,s.姓名,c.课程名 from s,c,sc where s.学号=sc.学号 and c.课程号=sc.课程号 and 班级 in ('B','C') and sc.成绩 between 70 and 80
