create a query to show the average salary of employees grouped by department and order the result by the average salary in descending order

SELECT department, avg(salary) from employees GROUP BY department ORDER BY avg(salary) DESC;