SQL server两表查询求大大解题

两表查询 统计出每种职位人数 并筛选出人数大于2的职位。要求显示职位名称

统计出每种职位人数解出来了 筛选人数大于二的职位不太会

在线等挺急的 求大佬解题

百度having，如再不会，谷歌having

select num,jobName from t_job t1 inner join (select count(*) as num,jbnId from t_user group by jbnId having num > 2) as t2 on t1.id = t2.jbnId

select z.jbnid as 人数,(select 职工类型名称 from 职工类型表 where id=z.id) from 职工表 as z inner join 职工类型表 as g on z.jbnid=g.id group by z.jnbid having(count(jbnid)>2)