[Exp 1]
Department & Employee Relational Analytics (Multi-Table JOINs)
UNIT-II
Rubric: 10m Code + 5m Viva +
5m Record
EASY
10 Marks
Session: 59:59
Bubblewrap Sandbox Active
Problem Statement
Write an SQL query using an `INNER JOIN` (or `LEFT JOIN`) between `departments` and `employees` to retrieve each department's name, total employee count, and the maximum salary earned in that department.
Query Requirements:
1. Select columns: `dept_name`, `total_employees`, `max_salary`.
2. Group records by department name.
3. Filter for departments that have at least 1 employee.
4. Order results by `max_salary` descending.
Click Run Code to evaluate against sample test
cases, or Submit Solution for full evaluation.
No compiler or execution errors recorded.
-- Write your SQL query here
SELECT
d.dept_name,
COUNT(e.emp_id) AS total_employees,
MAX(e.salary) AS max_salary
FROM departments d
JOIN employees e ON d.dept_id = e.dept_id
GROUP BY d.dept_name
ORDER BY max_salary DESC;