Average salary by department
Return each department and its average salary rounded to a whole number, highest average first.
Input
(none)
Expected output
Engineering | 160500 Sales | 110000 Support | 77500
Show a hint
ROUND(AVG(salary)) rounds to a whole number.
Show a solution
SQLLoading the editor…
Run the tests to check your solution.