Order the employee information by date of birth.
select * from employee order by emp_dob
Which of these employees have jobs as professors?
select * from employee where emp_jobcode = 'PROF' order by emp_dob
What are their first names?
select emp_fname from employee where emp_jobcode = 'PROF' order by emp_dob