Company SQL Question

Employees Earning Above Department Average

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

Problem Statement

Find all employees whose salary is higher than the average salary of their department. Show employee name, department name, employee salary, department average salary, and salary difference.

Relevant Tables

employeesdepartments

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
Window Functions FundamentalsWindow Functions
COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping