使用教学（STC）数据库，请将实现以下功能的SQL语句填写完整：： （10）将计算机系（'CS'）学生的成绩提高10%。[br][/br] update sc set grade= grade * where sno in[br][/br] (select sno from student where )
举一反三
- 关系SC(Sno，Cno，Grade)表示学号、课程号、成绩。现要查询最高分在91分以上的学生的学号和平均成绩，正确的语句是______。 A: SELECT Sno，MAX(Grade)<br> FROM SC<br> WHERE MAX(Grade)≥91<br> GROUP BY Sno B: SELECT Sno，MAX(Grade)<br> FROM SC<br> GROUP BY Sno<br> HAVING MAX(Grade)≥91 C: SELECT Sno，MAX(Grade)<br> FROM SC<br> WHERE MAX(Grade)≥91<br> ORDER BY Sno D: SELECT Sno，MAX(Grade)<br> FROM SC<br> GROUP BY Cno<br> HAVING MAX(Grade)≥91
- 使用教学（STC）数据库，请将实现以下功能的SQL语句填写完整：： （1）查询选修1号课程的学生学号。 select sno from sc where
- 下列SQL语句中，________可以在“学生-课程”数据库中实现“查询所有有成绩的学生学号和课程号”。 A: SELECT Sno，Cno FROM SC WHERE Grade <> NULL B: SELECT Sno，Cno FROM SC WHERE Grade NOT NULL C: SELECT Sno，Cno FROM SC WHERE Grade >0 D: SELECT Sno，Cno FROM SC WHERE Grade IS NOT NULL
- 查询曾经考过100分的学生的学号，可以使用的SQL语句是：（ ） A: SELECT ALL Sno FROM SC WHERE Grade = 100; B: SELECT DISTINCT Sno FROM SC WHERE Grade = 100; C: SELECT ALL Sno FROM Student WHERE SGrade = 100; D: SELECT DISTINCT Sno FROM Student WHERE SGrade = 100;
- 检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（ ） A: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >=ALL (SELECT Grade FROM SC WHERE Cno=’C1’); B: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’); C: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE > ANY (SELECT Grade FROM SC WHERE Cno=’C1’); D: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >= (SELECT Grade FROM SC WHERE Cno=’C1’);