SQL GROUP BY and HAVING | Dataford Interview Questions

Write a SQL query using GROUP BY and HAVING to find departments where the average employee salary is greater than a specific threshold.

Use the departments and employees tables. For this exercise, the threshold is 75000.

Output

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	Employee department reference
salary	NUMERIC(12,2)	Annual employee salary

Your question is SQL GROUP BY and HAVING. 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.

Write a SQL query using GROUP BY and HAVING to find departments where the average employee salary is greater than a specific threshold.

Use the departments and employees tables. For this exercise, the threshold is 75000.

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	Employee department reference
salary	NUMERIC(12,2)	Annual employee salary

Your question is SQL GROUP BY and HAVING. 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.