有关系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