Problem

Given a table of employee data, write a SQL query to find all employees who have been with the company for more than 5 years.
Example input:
| EmployeeID | Name       | StartDate       |
|------------|------------|-----------------|
| 1          | John Doe   | 01/01/2010      |
| 2          | Jane Smith | 03/04/2015      |
| 3          | Joe Brown  | 05/12/2012      |
Example output:
| EmployeeID | Name       | StartDate       |
|------------|------------|-----------------|
| 1          | John Doe   | 01/01/2010      |
| 3          | Joe Brown  | 05/12/2012      |

Solution

SELECT EmployeeID, Name, StartDate
FROM Employee
WHERE StartDate < DATEADD(year, -5, GETDATE())