'Sql: hackerrank aggregation

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.

Input Format

columns Types
ID Integer
Name string
Salary Integer

The EMPLOYEES table is described as follows:

Note: Salary is per month.

mysqlsql


Solution 1:[1]

MS SQL:

select cast(CEILING(avg(cast(salary as float)) - avg(cast(replace(salary,0,'') as float)))as int) from Employees

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Tyler2P

Related Questions