SQL Practice Logo

SQLPractice Online

Company SQL Question

Employees Earning Above Department Average

Practice this Amazon style SQL interview question with live execution and instant feedback.

Problem Statement

Find employees earning above their department average salary using a CTE.

Relevant Tables

employeesdepartments

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: