根据CJB输出各课程的平均成绩对应等级来定义学习难度:(平均成绩)80分以上者为“易学课”,70分以上者为“普通难度课”,70分以下者为“难学课”。查询结果中包含“课程号”、“学习难度等级”两列。类似的内容为: 课程号 其对应的SQL语句为:SELECT课程号, 学习难度等级 = __①__ FROM CJB __②__ 上述语句的空项内容为()
A.a B.b C.c D.d
A. SET @Cjb_Cur = CURSOR FOR SELECT * FROM CJB B. CREATE @CURSOR Cjb_Cur AS SELECT * FROM CJB C. DECLARE @Cjb_Cur AS TABLE CJB D. DECLARE @Cjb_Cur CURSOR FOR SELECT * FROM CJB
A. DECLARE Kcb_Cur CURSOR FOR SELECT * FROM KCB B. SET Kcb_Cur = CURSOR FOR SELECT * FROM KCB C. CREATE CURSOR Kcb_Cur AS SELECT * FROM KCB D. DECLARE Kcb_Cur AS TABLE KCB