SQL数据库问题

1.select 姓名,datediff(year,出生日期,getdate()) as 年龄 from worker 2.select a.部门名,count(b.部门号) as 人数 from depart a,worker b where a.部门号=b.部门号 and b.党员否=1 group by b.部门号, a.部门名 3.select 姓名,工资 from salary where 日期 between '2004-01-01' and '2004-0