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