Sure! Here's a MySQL query question for you:

Consider a table named employees with the following columns:

• employee_id (Primary Key)
• first_name
• last_name
• department
• salary

Write a SQL query to find the average salary for each department, along with the total number of employees in each department. Sort the result by the average salary in descending order.

Answer rating: 100% (QA)

You can use the following SQL query to achieve this sql SELECT department AVGsa... View the full answer