Question: Sql Server- Create a query that will show those employees that left Auntie B's in 2014. In your output show the people id, hire date,
Sql Server-
Create a query that will show those employees that left Auntie B's in 2014. In your output show the people id, hire date, term date and years employeed. In your output include people id and the number of years employed. Title this last column "Years Employed".
PeopleID HireDate TermDate Years Employed
----------- ---------- ---------- ---------------
1016 2010-06-22 2014-01-15 4
1029 2010-02-10 2014-02-05 4
How do I turn two dates into amount of years?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
