Database: college_1
Question: What are the first names of all employees that are professors ordered by date of birth?
SQL:
SELECT emp_fname FROM employee WHERE emp_jobcode  =  'PROF' ORDER BY emp_dob