SQL query to filter departments by employee count and salary threshold
Filed under Oracle
The question
Write an SQL query to retrieve all departments that have at least 6 employees with salaries exceeding 7000.
No write-up yet. Related questions below have one.
Related Oracle questions
Collected from public candidate posts and coding forums. Updated Nov 2026.