Give the name of the lowest earning instructor in the Statistics department.
SELECT name FROM instructor WHERE dept_name  =  'Statistics' ORDER BY salary LIMIT 1
lowest earning = MIN(salary); instructor in the Statistics department refers to WHERE dept_name = 'Statistics'; name of the instructor refers to SELECT name;