求解oracle习题.10.Write a query to display the department name,location name,number of employees,and the average salary for all employees in that department.Label the columns’ dname,loc,Number of People,and Salary,respectively.DNAME LOC Number
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/17 23:00:44
求解oracle习题.
10.Write a query to display the department name,location name,number of employees,and the average salary for all employees in that department.Label the columns’ dname,loc,Number of People,and Salary,respectively.
DNAME LOC Number of People Salary
------------ --------- ---------------- --------
ACCOUNTING NEW YORK 3 2916.67
RESEARCH DALLAS 5 2175
SALES CHICAGO 6 1566.67
select d.dname,d.loc,count(e.*) as "Number of People",avg(e.salary) salary
from department d, employees e
where d.dno=e.dno
group by d.dname,d.loc ;
大概是这样了
求解oracle习题.10.Write a query to display the department name,location name,number of employees,and the average salary for all employees in that department.Label the columns’ dname,loc,Number of People,and Salary,respectively.DNAME LOC Number
模电习题求解
弹性力学习题求解
工程制图习题求解
大一电路习题求解
概率论习题,求解,谢谢.
生物习题,求解
线性代数习题求解
理论力学习题求解
高数习题求解
电路习题,求解.
复变函数习题求解
求解分式方程100习题
概率论与数理统计习题求解.
概率论与数理统计习题求解,..
求解一份数电习题,
高数大一习题求解
求解有机化学习题烷烃环烷烃