SQL Aggregation for HR Headcount

EasySQL · PostgreSQL

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

Tablesemployees

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.