What is the average salary for the physics department?
SELECT avg ( salary )  FROM instructor WHERE  dept_name   =   'Physics'
average salary refers to AVG(salary); for the physics department refers to WHERE dept_name = 'Physics';