I don't think the HAVING solution calculates the average salary per year. I believe the query would need to take into account the start/end dates (maybe take the sum of salaries divided by the difference in dates). Many end dates are "9999-01-01". These might be the contracts mentioned in the solution, but it's not really clear. In any case, those end dates don't make sense, so the data provided is unreliable in some sense when doing calculations based on end dates.

Hi Luke! Thanks for reaching out. The average salary is calculated when you sum all salaries of the current employee and divide by the number of records for this particular employee. If an employee has 10 different periods of work we sum up these 10 salaries and divide the result by 10. If this calculation is bigger than 120 000$ then it is included in the result set. When using WHERE instead of HAVING, the output is larger because in the output we include individual contracts higher than $120,000 per year. Hope this helps. Best, Martin

Follow this topic

Luke LaJoie

Last answered:

16 Dec 2021

Posted on:

08 Nov 2021

Average salary per year?

in SQL / HAVING

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

16 Dec 2021

Average salary per year?

Submit an answer

related questions