Your question is Employees Joined This Year. Start with the requirements and the one table on the right.
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.
NULL join dates.| 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 |