Monday, March 11, 2024

Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeros removed), and the actual average salary. Write a query calculating the amount of error (i.e.: average monthly salaries), and round it up to the next integer.

 SELECT ROUND((AVG(Salary)    -    AVG(CAST(REPLACE(Salary, 0, '') AS int)))+1) FROM Employees;

No comments:

Post a Comment

LeetCode 4 Median of Two Sorted Arrays in JavaScript

LeetCode 4, Median of Two Sorted Arrays , asks us to find the median of two already sorted arrays without actually merging them. The key ...

horizontal ads