Oracle经典查询练手第一篇

--1.	哪些部门的人数比90 号部门的人数多。  
select department_id ,count(*)
from employees
group by department_id
having count(*)>(select count(*) from employees where department_id=90);

--2.	Den(FIRST_NAME)、Raphaely(LAST_NAME)的领导是谁(非关联子查询)。  
select  first_name||' '||last_name from employees where employee_id = (
  select manager_id from employees where first_name='Den' and last_name='Raphaely');

--3.	Den(FIRST_NAME)、Raphaely(LAST_NAME) 领导谁(非关联子查询)。  
select  first_name||' '||last_name from employees where manager_id = (
  select employee_id from employees where first_name='Den' and last_name='Raphaely');

--4.	Den(FIRST_NAME)、Raphaely(LAST_NAME) 的领导是谁(关联子查询)。  
select first_name||' '||last_name 
from employees a
where exists
  (select 1 from employees b
    where a.employee_id=b.manager_id
      and b.first_name='Den' 
      and b.last_name='Raphaely');