Practice Interview Questions
| Question | Status |
|---|---|
Write a query to find the names of employees who were still employed as of January 2, 2016.
employees table:
| Column Name | Description |
|---|---|
| id | Identifier for each employee |
| name | Name of the employee |
| hire_date | Date the employee was hired |
terminations table:
| Column Name | Description |
|---|---|
| emp_id |
Write a query to find the names of employees who were still employed as of January 2, 2016.
employees table:
| Column Name | Description |
|---|---|
| id | Identifier for each employee |
| name | Name of the employee |
| hire_date | Date the employee was hired |
terminations table:
| Column Name | Description |
|---|---|
| emp_id |
| Employee ID |
| term_date | Date of the employee's termination |
| name |
|---|
| Ian Jenkins |
| Julia Knight |
| Tina Underwood |
| Kevin Lutz |
| Employee ID |
| term_date | Date of the employee's termination |
| name |
|---|
| Ian Jenkins |
| Julia Knight |
| Tina Underwood |
| Kevin Lutz |