该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
写出来了。。。
select last_name,department_id ,case department_id
when 10 then (select count(*) from employees where department_id=10)
when 20 then (select count(*) from employees where department_id=20)
when 30 then (select count(*) from employees where department_id=30)
when 40 then (select count(*) from employees where department_id=40)
when 50 then (select count(*) from employees where department_id=50)
when 60 then (select count(*) from employees where department_id=60)
when 70 then (select count(*) from employees where department_id=70)
when 80 then (select count(*) from employees where department_id=80)
when 90 then (select count(*) from employees where department_id=90)
when 100 then (select count(*) from employees where department_id=100)
when 110 then (select count(*) from employees where department_id=110)
else null end "count"
from employees
group by last_name,department_id