假设有三个基本表:学生表S、课程表C、学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE) 检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SQL语句是()。
A.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=”王华”)
B.SELECT SN,AGE,SEX FROM S WHERE SN=”王华”
C.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=”王华”)
D.SELECT SN,AGE,SEX FROM S WHERE AGE>王华.AGE