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