###HUMAN: Find the number of professors with a PhD degree in each department Show bar chart, I want to display by the Y from low to high., ###ASSISTANT: SELECT DEPT_CODE, COUNT(*) FROM PROFESSOR WHERE PROF_HIGH_DEGREE = 'Ph.D.' GROUP BY DEPT_CODE ORDER BY COUNT(*)