Q: SQl query Find minimum, maximum and average salaries of the managers.?

 Q: SQl query Find minimum, maximum and average salaries of the managers.?

Ans: Here is an example of a SQL query that can be used to retrieve the minimum, maximum and average salaries of the managers:

SELECT MIN(salary) as min_salary, MAX(salary) as max_salary, AVG(salary) as avg_salary FROM managers;

This query retrieves the minimum, maximum and average salary of the managers from the managers table. The query uses the MIN() function to retrieve the minimum salary, the MAX() function to retrieve the maximum salary, and the AVG() function to retrieve the average salary of the managers.

This query assumes that there is a table "managers" which contains a column named "salary". Please keep in mind that table names, column names and the actual query may vary depending on the database structure and naming conventions used.

No comments:

Post a Comment