教学数据库的三个基本表如下。学生SS#SNAMEACESEX学习SCS#C#GRADE课程CC#CNAMETEACHER其中#表示主键试用SOL的查询语句表达下列要求。1检索年龄大于23岁的男学生的学号和姓名2检索王同学不学的课程号。3创建一个存储过程根据用户键入的学生学号S#和课程号C#查询学生成绩grade。

(1) SELECT S#, SNAME FROM S WHERE SEX='男' AND ACE>23; (2) SELECT C# FROM C WHERE C# NOT IN (SELECT C# FROM SC WHERE S#=(SELECT S# FROM S WHERE SNAME='王')); (3) CREATE PROCEDURE getGrade(IN studentNo VARCHAR(10), IN courseNo VARCHAR(10)) BEGIN SELECT GRADE FROM SC WHERE S# = studentNo AND C# = courseNo; END;