A.
CREATE VIEW AGE LIST AS SELECT学号,姓名,YEAR(DATEQ)-YEAR(出生日期)年龄FROM学生; SELECT学号,姓名,年龄FROM AGE LIST WHERE年龄=22
B.
CREATE VIEW AGE LIST AS; SELECT学号,姓名,YEAR(出生日期)FROM学生;SELECT学号,姓名,年龄FROM AGE -L IST WHERE YEAR(出生日期)=22
C.
CREATE VIEW AGE LIST AS; SELECT学号,姓名,YEAR(DATEQ)-YEAR(出生日期)年龄FROM学生; SELECT学号,姓名,年龄FROM学生WHERE YEAR(出生日期)=22
D.
CREATE VIEW AGE LIST AS STUDENT; SELECT学号,姓名,YEAR(DATE())-YEAR(出生日期)年龄FROM学生;SELECT学号,姓名,年龄FROM STUDENT WHERE年龄=22