instruction: How many professors for each first name? Show me a bar chart, and show in ascending by the x axis.
response: SELECT EMP_FNAME, COUNT(EMP_FNAME) FROM PROFESSOR AS T1 JOIN EMPLOYEE AS T2 ON T1.EMP_NUM = T2.EMP_NUM GROUP BY EMP_FNAME ORDER BY EMP_FNAME