Yes show average salary grouped over each department name.
select dept_name, avg ( salary ) from instructor group by dept_name
Show the department with the lowest average salary.
select dept_name from instructor group by dept_name order by avg ( salary ) asc limit 1