text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE employee (emp_fname VARCHAR, emp_jobcode VARCHAR, emp_dob VARCHAR)
  ### Question:
  List the first name of all employees with job code PROF ordered by their date of birth.
  ### Answer:
  SELECT emp_fname FROM employee WHERE emp_jobcode = 'PROF' ORDER BY emp_dob