← Wells Fargo questions
CodingReported in a candidate post, Sep 2024

Count employees earning above their department average

Filed under Wells Fargo

Given an employees table (id, name, dept_id, salary), write a SQL query that returns the number of employees earning more than the average salary of their own department.

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Wells Fargo questions

Collected from public candidate posts and coding forums. Updated Nov 2026.