List the first name of all employees with job code PROF ordered by their date of birth.
CREATE TABLE employee (
    emp_fname VARCHAR,
    emp_jobcode VARCHAR,
    emp_dob VARCHAR
)
SELECT emp_fname FROM employee WHERE emp_jobcode = 'PROF' ORDER BY emp_dob
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: List the first name of all employees with job code PROF ordered by their date of birth. ### Input: CREATE TABLE employee (
    emp_fname VARCHAR,
    emp_jobcode VARCHAR,
    emp_dob VARCHAR
) ### Response: SELECT emp_fname FROM employee WHERE emp_jobcode = 'PROF' ORDER BY emp_dob