SQL Query help

Question

Dear Team,

I am trying to submit a Final Assignment for the SQL Essential course that I have taken. Out Of 19 Problem statements I am able to close 17 but below mentioned two problem statements are unsolved by me. Can you please help me with this.

Problem statement  15

Retrieve the average salary of employee per department

Query

Problem Statement 19

Create a view to fetch the details of employee with following columns

 Emp_Id

 Name

 Dept ,

 Dep_Id,

 Age

 Salary