Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeroes removed), and the actual average salary.
Write a query calculating the amount of error (i.e.:actual - miscalculated average monthly salaries), and round it up to the next integer.
The EMPLOYEES table is described as follows:
Note : Salaryis measured in dollars per month and its value is < 10^5.
The table below shows the salarieswithout zeroesas they were entered by Samantha:
Samantha computes an average salary of 98.00. Theactualaverage salary is 2159.00
The resulting error between the two calculations is 2159.00 - 98.00 = 2061.00 which, when rounded to the next integer, is. 2061
SELECT CEIL(AVG(Salary) - AVG(REPLACE(Salary, 0, ''))) FROM EMPLOYEES
|[HackerRank] Basic Aggregation : Weather Observation Station (0)||2021.02.09|
|[HackerRank] Basic Aggregation : Top Earners (0)||2021.02.09|
|[HackerRank] Basic Aggregation : The Blunder (0)||2021.02.09|
|[HackerRank] Basic Aggregation : Revising Aggregations (0)||2021.02.09|
|[HackerRank] Basic Join : Top Competitors (0)||2021.02.08|
|[HackerRank] Basic Join : The Report (2)||2021.02.08|