Problem
Many companies celebrate work anniversaries and long tenure as part of their culture. Before a company-wide all-hands meeting, HR pulls the five most tenured employees to give them public recognition. The earliest hire dates represent the longest-serving employees regardless of how many years ago they joined. Using the employees table, return id, name, and hire_date for the 5 employees with the earliest hire dates, ordered by hire_date ascending.
Schema
employees
| column | type |
|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | NUMERIC |
| hire_date | DATE |
Sample Data
| id | name | hire_date |
|---|
| 1 | Alice | 2010-03-01 |
| 2 | Bob | 2008-07-15 |
| 3 | Carol | 2015-01-10 |
| 4 | Dave | 2007-11-20 |
| 5 | Eve | 2012-06-30 |
Expected Output
| id | name | hire_date |
|---|
| 4 | Dave | 2007-11-20 |
| 2 | Bob | 2008-07-15 |
| 1 | Alice | 2010-03-01 |
| 5 | Eve | 2012-06-30 |
| 3 | Carol | 2015-01-10 |