Which department has the lowest average salary of professors?
SELECT dept_name FROM instructor GROUP BY dept_name ORDER BY avg ( salary )   LIMIT 1
lowest average salary refers to MIN(AVG(salary)); department refers to dept_name;