36

Department Average Salary

MediumAVGGROUP BYROUND

Problem Description

Write a SQL query to find the average salary for each department, rounded to 2 decimal places.

Example Output

| department | avg_salary | |------------|------------| | Engineering | 81400.0 | | Finance | 81500.0 | | HR | 57500.0 | | Marketing | 66333.33 | | Sales | 71000.0 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#36 Department Average Salary
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results