JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

MediumsubquerySQL

Employees With Above-Average Department Salary

A department head wants to recognize employees who earn above-average salaries compared to others in their department, in order to highlight high performers for potential rewards.

Return

name (the employee's name) salary (the employee's salary) department_id (the department the employee belongs to) Only include employees who are assigned to a department and whose salary is higher than the average salary of their department. Results can be in any order.

Expected output

name	salary	department_id
3 rows — values hidden, that's the puzzle

Your query should return 3 rows with these columns. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.

Employees With Above-Average Department Salary | Algorithm