Find the SQL code for the following business question. The company would like to see how long its employees have

Find the SQL code for the following business question. The company would like to see how long its employees have

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.

Expert Answer:

Answer rating: 100% (QA)

SELECT first name last name TIMESTAMPDIF
View the full answer