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
first name of employees = emp_fname; with job code PROF refers to emp_jobcode = 'PROF'; ordered by their date of birth refers to ORDER BY emp_dob;