The company would like to see how long its employees have been with the organization less than 15 years as of 1/01/2023. Create a query that provides the first name, last name, and the time with the company (Tenure) for only those employees that are still with the organization. Make sure to show the longest tenured employees first. No other dates or parameters should be used outside of what has been provided to get the results required. You have been provided with all the information required to develop the query.

New Database Open Database. Table: department \begin{tabular}{|l|l|l|l|l|} \hline & Departmentld & DepartmentName & Locationld & Manager \\ \cline { 4 - 5 } & Filter & Filter & Filter & Filter \\ \hline 1 & 1 & Administration & 1700 & 102 \\ \hline 2 & 2 & Marketing & 1800 & 201 \\ \hline 3 & 3 & Purchasing & 1700 & 114 \\ \hline 14 & 4 & Human Resources & 2400 & 203 \\ \hline 5 & 5 & Shipping & 1500 & 122 \\ \hline 6 & 6 & IT & 1400 & 106 \\ \hline 7 & 7 & Public Relations & 2700 & 204 \\ \hline 8 & 8 & Sales & 2500 & 146 \\ \hline 9 & 9 & Executive & 1700 & 101 \\ \hline 10 & 10 & Finance & 1700 & 108 \\ \hline 11 & 11 & Accounting & 1700 & 205 \\ \hline 12 & 12 & IT & 2400 & 106 \\ \hline 13 & 13 & IT & 1500 & 106 \\ \hline 14 & 14 & IT & 1700 & 106 \\ \hline 15 & 15 & Sales & 1700 & 145 \\ \hline 16 & 18 & Shipping & 1400 & 123 \\ \hline & & & \\ \hline \end{tabular} Database Open Database Open Project Save P1 Database Structure Browse Data Edit Pragmas employee