Department with Highest Average

Medium
subqueries

Write a query to find the department with the highest average salary. Return columns department and avg_salary (rounded to 2 decimal places). If there is a tie, return all tied departments ordered by department.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...