查询SC表中课程号为'10010001'的学号、成绩、调整成绩(调整成绩=原成绩开平方后再乘以10)。
A.
UPDATE sc SET cj=SQRT(cj)*10; SELECT sno AS 学号, cno AS 课程号, cj AS 调整成绩 FROM sc WHERE cno='10010001';
B.
SELECT sno AS 学号, cno AS 课程号, cj AS 原成绩, SQRT(cj)*10 AS 调整成绩 FROM sc WHERE cno='10010001';
C.
UPDATE sc SET cj=SQRT(cj)*10; SELECT sno AS 学号, cno AS 课程号, cj AS 原成绩, SQRT(cj)*10 AS 调整成绩 FROM sc WHERE cno='10010001';
D.
SELECT sno AS 学号, cno AS 课程号, cj AS 原成绩, SQRT(cj)*10 AS 调整成绩 FROM sc HAVING cno='10010001';