SQL Query With Joins And Grouping | Dataford Interview Questions

Write a SQL query using GROUP BY, INNER JOIN, and ORDER BY.

Use the provided department and employee tables. Return only departments with at least one matching employee, summarize employee counts and salaries, and sort the results by total salary from highest to lowest.

Output

One row per department
Columns: department_name, employee_count, and total_salary
Exclude departments without employees and employees without a matching department
Sort by total_salary descending, with NULL totals last, then department_name ascending

Schema

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department display name

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INT	Employee department reference
salary	DECIMAL(12,2)	Annual employee salary

Your question is SQL Query With Joins And Grouping. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem