devxlogo

Calculating and Using Averages

Calculating and Using Averages

Question:
Can I determine which employees have received a salary for a month that is more than twice the average salary in that month? I need to show:month_number, average salary, name of highly paid employee(s), salary.

Answer:
Yes, a SQL statement similar to this should work:

    SELECT month_number, AVG(salary), name, salary FROM Employees        WHERE salary > ((AVG(salary))*2);
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist