Create a view to include department name and average salary by department.

Question

Use case study databases for the following queries.

Answer 1

```
SQL> CREATE OR REPLACE VIEW DEPT_SAL_VU
2 AS
3 SELECT DEPTID, AVG(SALARY) AVGSALARY
4 FROM EMPLOYEE
5 GROUP BY DEPTID;

VIEW CREATED.

SQL> SELECT * FROM DEPT_SAL_VU;

DEPTID AVGSALARY
---------- ----------
10 125000
20 73250
30 34750
40 150000
```