Correlated subquery for per-row condition

SQL Easy 2 views
Back to Questions
Previous Subquery in FROM (derived table) Easy P Next Find latest order per customer using subquery Medium N

Problem Description

List employees who earn more than the average salary of their own department.

Input Format

SQL query

Output Format

Result set

Sample Test Case

Input:
Employees(dept_id, salary)
Output:
Employee list

Constraints

Correlated avg
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next