← All problemsExample 1
Problem
Departments With More Than One Employee
Medium- sql
Return the departments that have more than one employee, together with how many employees each has.
Expected columns: dept and n (the employee count). Row order does not matter.
- Input
Employees(id, name, dept, salary) 1 | Alice | Sales | 50000 2 | Bob | Sales | 60000 3 | Carol | IT | 70000 4 | Dave | IT | NULL 5 | Eve | HR | 55000- Output
dept | n IT | 2 Sales | 2- Explanation
HR has one employee, and Finance has none, so neither is listed.
Sample database
Your query runs in the browser against these tables. Column names are exact.
Departments
- dept_id
- dept
Employees
- id
- name
- dept
- salary
Customers
- customer_id
- name
- city
- signup_date
Products
- product_id
- name
- category
- price
Orders
- order_id
- customer_id
- order_date
- status
OrderItems
- order_id
- product_id
- quantity
Logins
- customer_id
- login_date
Staff
- staff_id
- name
- title
- manager_id
No automatic grading here
Run your query and check the rows against what the question asks for. Then open the model answer to compare.
SQL
Tab indents. Press Esc, then Tab to leave the editor.
Ctrl or ⌘ + Enter runs the query.
Loading the SQL engine…