instruction: Find the number of professors with a PhD degree in each department Show bar chart, I want to order y-axis from high to low order.
response: SELECT DEPT_CODE, COUNT(*) FROM PROFESSOR WHERE PROF_HIGH_DEGREE = 'Ph.D.' GROUP BY DEPT_CODE ORDER BY COUNT(*) DESC