在“职工”表中有姓名、性别和生日等3个字段,要查询所有年龄大于50岁职工的姓名、性别和年龄,正确的SQL命令是
A. SELECT姓名,性别,YEAR(DATE())-YEAR([生日]) AS 年龄 FROM 职工 WHERE YEAR(Date())-YEAR([生日])>50
B. SELECT姓名,性别,YEAR(DATE())-YEAR([生日]) 年龄 FROM 职工 WHERE YEAR(Date())-YEAR([生日])>50
C. SELECT姓名,性别,YEAR(DATE())-YEAR([生日]) AS 年龄 FROM 职工 WHERE 年龄>50
D. SELECT姓名,性别,YEAR(DATE())-YEAR([生日]) 年龄 FROM 职工 WHERE 年龄>50