Answer:
SELECT TECHNAME, EMPNUM, YEAR FROM EMPLOYEE ORDER BY YEAR DESC
Explanation:
The table definition is not given;
However, I'll make the following assumptions
Table Name:
Employee
Columns:
Technician name will be represented with Techname
Employee number will be represented with Empnum
Year Hired will be represented with Year
Having said that; the sql code is as follows:
SELECT TECHNAME, EMPNUM, YEAR FROM EMPLOYEE ORDER BY YEAR DESC
The newest year hired will be the largest of the years;
Take for instance:
An employee hired in 2020 is new compared to an employee hired in 2019
This implies that the year has to be sorted in descending order to maintain the from newest to oldest.
