SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Departments with High Average Salary

Build mastery in Aggregations with this scenario-based SQL challenge and live execution support.

Problem Statement

Find departments where the average salary is above $70,000. Use HAVING clause.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: