CREATE TABLE employee (emp_fname VARCHAR2, emp_jobcode VARCHAR2, emp_dob VARCHAR2)

List the first name of all employees with job code PROF ordered by their date of birth.
SELECT emp_fname FROM employee WHERE emp_jobcode = 'PROF' ORDER BY emp_dob
SELECT "emp_fname" FROM "employee" WHERE "emp_jobcode" = 'PROF' ORDER BY "emp_dob"