Question

Write a query to display the Sum Average, highest and Lowest salary of the employees. ​

Answer 1

Answer:

Code:

SELECT ROUND(MAX(salary),0) 'Maximum', ROUND(MIN(salary),0) 'Minimum',

ROUND(SUM(salary),0) 'Sum',

ROUND(AVG(salary),0) 'Average'

FROM employees;

Answer 2

Answer:

SELECT SUM(salary) AS total_salary, AVG(salary) AS avg_salary,

MAX(salary) AS highest_salary, MIN(salary) AS lowest_salary

FROM employees;