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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!