Find the average salary of the professors of each department?
SELECT avg ( salary ) , dept_name FROM instructor GROUP BY dept_name
average salary refers to AVG(salary); professors of each department refers to grouping by dept_name;