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