Find the SQL code for the following business question. The company would like to see how long
Fantastic news! We've Found the answer you've been seeking!
Question:
Find the SQL code for the following business question. The company would like to see how long its employees have been with the organization for over 15 years as of 6/01/2022. The query needs to provide the first name, last name, and the time with the company (TimeWithCo) for only those employees that are still with the organization. Make sure to show the longest tenured employees first.
Related Book For
Management A Practical Introduction
ISBN: 978-0078112713
5th edition
Authors: Angelo Kinicki, Brian Williams
Posted Date: