instruction: List the first name of all employees with job code PROF ordered by their date of birth, and count them by a bar chart
response: SELECT EMP_FNAME, COUNT(EMP_FNAME) FROM EMPLOYEE WHERE EMP_JOBCODE = 'PROF' GROUP BY EMP_FNAME ORDER BY EMP_DOB