有关系S(SNO, SNAME, SDEPT,SAGE),C(CNO, CNAME),SC(SNO, CNO, GRADE)。其中SNO是学生号,SNAME是学生姓名,SDEPT是系别,SAGE是学生年龄, CNO是课程号,CNAME是课程名称,GRADE是成绩。下列查询语句语法正确的是( )。
A、DELETE FROM S,SC
WHERE S,Sno=SC.Sno AND Sname LIKE '李%'
B、UPDATE FROM SC
SET Grade=Grade+10
WHERE Sno = (SELECT Sno FROM SC WHERE Grade <60)
C、SELECT S1.Sno,Sname
FROM S1 JOIN SC
ON S1.Sno = SC.Sno
WHERE Grade >= min(Grade)
D、SELECT S1.Sno,Sname
FROM (SELECT Sno,Sname FROM S
WHERE Sdept='计算机' ) S1 JOIN SC
ON S1.Sno = SC.Sno
WHERE Grade >=60
A、DELETE FROM S,SC
WHERE S,Sno=SC.Sno AND Sname LIKE '李%'
B、UPDATE FROM SC
SET Grade=Grade+10
WHERE Sno = (SELECT Sno FROM SC WHERE Grade <60)
C、SELECT S1.Sno,Sname
FROM S1 JOIN SC
ON S1.Sno = SC.Sno
WHERE Grade >= min(Grade)
D、SELECT S1.Sno,Sname
FROM (SELECT Sno,Sname FROM S
WHERE Sdept='计算机' ) S1 JOIN SC
ON S1.Sno = SC.Sno
WHERE Grade >=60