Subquery with IN for Filtering
Medium
subqueries
Capital One
JPMorgan
PayPal
Write a query to find all employees who work in departments that have more than 2 employees. Use a subquery with IN. Return name and department, ordered by name.
Expected Output: Employees in departments with 3+ members.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...