| Emp Id | Last Name | First Name | Dept Name | BirthDate | Hire Date | Salary |
|---|---|---|---|---|---|---|
| 101 | Smith | Tom | Accounting | 1970-02-20 | 1993-06-06 | 50000.00 |
| 103 | Jones | Mary | Accounting | 1975-06-15 | 2005-09-20 | 48000.00 |
| 105 | Burns | Jane | Accounting | 1980-09-21 | 1990-06-12 | 39000.00 |
| 110 | Burns | Michael | Research | 1977-05-04 | 2010-09-10 | 70000.00 |
| 115 | Chin | Amanda | Research | 1980-09-22 | 2014-06-19 | 60000.00 |