问题详情

给所有的选修课号为"0001"的女生的该课程成绩增加5分，使用的语句为_____

A UPDATE SKB SET 成绩 WITH 成绩+5 WHERE 课号 = “0001”AND 性别= “女”

B UPDATE SKB SET 成绩 = 成绩+5 WHERE 课号 = “0001”AND 性别 =“女”

C UPDATE SKB SET 成绩 = 成绩+5 WHERE 课号 = “0001”AND 学号 IN (SELECT * FROM STUDENT WHERE 性别 = “女”)

D UPDATE SKB SET 成绩 WITH 成绩+5 WHERE 课号 = “0001”AND 学号 IN (SELECT * FROM STUDENT WHERE 性别 = “女”)