34,590
社区成员
发帖
与我相关
我的任务
分享
select j.job_desc,count(*)
from Employee e inner join Jobs j on e.job_id=j.job_id
group by j.job_desc
select t.job_desc,count(r.emp_id) as 人数
from Employee r join Jobs t
on r.job_id = t.job_id
group by t.job_desc
select j.job_desc,count(*)
from Employee e inner join Jobs j on e.job_id=j.job_id
group by j.job
select e.*,j.job_desc
from jobs j
inner join
(
select job_id,Max_lvl=max(job_lvl),Min_lvl=min(job_lvl)
from employees
group by job_id
) e on j.job_id = e.job_id