Find Average Salary

Problem Statement: Write a query to find the average salary of the employees for each department. Save the new average salary as 'Average_salary'. Return the columns 'department_id', 'department_name', and 'Average_salary'. Return the result order...