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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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. [/INST] SELECT emp_fname FROM employee WHERE emp_jobcode = 'PROF' ORDER BY emp_dob </s>