SQL Aggregation for HR Headcount | Dataford Interview Questions

Write a SQL query to find the total number of employees working in the HR department from an employees table.

Use the employees table and count only rows whose department is HR.

Output

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(50)	Department assigned to the employee

Your question is SQL Aggregation for HR Headcount. Start with the requirements and the one table 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 to find the total number of employees working in the HR department from an employees table.

Use the employees table and count only rows whose department is HR.

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(50)	Department assigned to the employee

Your question is SQL Aggregation for HR Headcount. Start with the requirements and the one table 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.