主题：查询练习——公司职员信息

现在有如下员工关系数据库 Employee (employee_ name, street, city) Works (employee_ name, company_ name, salary) Company (company_ name, city) Manages (employee_ name, manager_ name) 用SQL语句实现下面题目

点击下载示例数据库（Access版本）

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:

1，找出比HP的员工收入都高的所有员工的姓名； select employee_name from works where salary >(select max(salary) from works where company_name='HP')

2，找出与其经理居住在同一城市同一街道的员工的姓名； select E.employee_name from Employee as E inner join Manages on E.employee_name=Manages.employee_name inner join Employee M on M.employee_name=Manages.manager_name where E.stree=M.stree and E.city=M.city

3，找出员工最多的公司 select top 1 company_name from works group by company_name order by count(*) desc

4，找出平均工资高于HP平均工资的所有公司 select company_name from works group by company_name having avg(salary)>(select avg(salary) from works where company_name='HP')

5，找出工资高于其所在公司员工平均工资的所有员工； select employee_name from works as W1 where salary>(select avg(salary) from works group by company_name having company_name=W1.company_name)