Display each employee’s last name, hire date, and salary review date, which is the first Tuesday after a year of service, but only for those hired after 1997.
Label the column REVIEW DAY.
Format the dates to appear in the format similar to
TUESDAY, August the Thirty-First of year1998
1 SELECT last_name, hire_date, TO_CHAR (hire_date, 'DAY "," Month "the" Ddsp "of year" YYYY') "Review Day" 2 FROM EMPLOYEES 3* WHERE TO_CHAR(hire_date, 'DY') = 'TUE' and hire_date > '1-Jan-1997'
TUESDAY , November the Sixteen of year 1999
TUESDAY , March the Twenty-Four of year 1998