instruction: A bar chart about how many professors have a PhD in each department?, display from high to low by the X.
response: SELECT DEPT_CODE, COUNT(*) FROM PROFESSOR WHERE PROF_HIGH_DEGREE = 'Ph.D.' GROUP BY DEPT_CODE ORDER BY DEPT_CODE DESC