All Problems
51

Having Clause - High Earners

MediumHAVINGAVGGROUP BY

Problem Description

Write a SQL query to find departments where average salary is above 70000.

Expected Columns

  • department
  • avg_salary

Example Output

| department | avg_salary | |------------|------------| | Engineering | 81400.0 | | Finance | 81500.0 | | Sales | 71000.0 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#51 Having Clause - High Earners
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results