TTITLE 'RobAir - Pilot Proficiency Test Status'
COLUMN pil_pt135_date -
HEADING 'Last Proficiency Test'
COLUMN req_test_date -
HEADING 'Next Proficiency Test'
SELECT (e.emp_fname ||' '|| e.emp_lname) Pilot, p.pil_pt135_date,
(ADD_MONTHS(p.pil_pt135_date,6)) req_test_date
FROM hartmar.employee e join hartmar.pilot p on e.emp_num = p.emp_num
WHERE ADD_MONTHS(p.pil_pt135_date,6) < ADD_MONTHS(CURRENT_DATE,3)
;