select 姓名,性别,year(getdate())-year(出生年月) as 年龄 from 职工
where year(getdate())-year(出生年月)>35
--(5)查询有名以上（含名）职工的部门名称和职工人数，并按职工人数降序排序
select 部门号,count(部门号) from 职工
group by 部门号
having count(部门号)>1
order by count(部门号) desc
select 部门名,count(zg.部门号) as 人数 from 职工zg join 部门bm on zg.部门号=bm.部门号 group by 部门名
having count(zg.部门号)>1
order by count(zg.部门号) desc
11