Employees Joined This Year | Dataford Interview Questions

Find how many employees joined this company during this year.

Asked in the Virtual Onsite stage. SQL question asked during interview rounds.

Task

Write a SQL query to count employees whose join_date falls in the current calendar year.

employees

Column	Type	Description
employee_idPK	INT	Primary key for each employee
employee_name	VARCHAR(255)	Employee full name
join_date	DATE	Date the employee joined the company

Your question is Employees Joined This Year. 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.

Find how many employees joined this company during this year.

Asked in the Virtual Onsite stage. SQL question asked during interview rounds.

Write a SQL query to count employees whose join_date falls in the current calendar year.

employees

Column	Type	Description
employee_idPK	INT	Primary key for each employee
employee_name	VARCHAR(255)	Employee full name
join_date	DATE	Date the employee joined the company

Your question is Employees Joined This Year. 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.