- Prepare
- SQL
- Aggregation
- The Blunder

# The Blunder

# The Blunder

- Prepare
- SQL
- Aggregation
- The Blunder

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**

The **EMPLOYEES** table is described as follows:

**Note:** *Salary* is per month.

**Constraints**

.

**Sample Input**

**Sample Output**

```
2061
```

**Explanation**

The table below shows the salaries *without zeros* as they were entered by Samantha:

Samantha computes an average salary of . The *actual* average salary is .

The resulting error between the two calculations is . Since it is equal to the integer , it does not get rounded up.