What is the lowest salary of the instructors in the statistics department?
SELECT min ( salary )  FROM instructor WHERE dept_name   =   'Statistics'
lowest salary refers to MIN(salary); instructors in the statistics department refers to WHERE dept_name = 'Statistics';