SQL Inner Join and Aggregate | Dataford Interview Questions

Write a SQL query to retrieve data from two tables using an inner join and aggregate the results.

Use the provided departments and employees tables. Return one row for each department with at least one matching employee.

Output

Return department_name, employee_count, and total_salary.
Count employees, sum non-null salaries, and exclude departments without matching employees.
Order by total_salary descending, then department_name ascending.

departments

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

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
department_id	INT	Referenced department identifier
salary	INT	Employee salary

Your question is SQL Inner Join and Aggregate. 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.