And what is the name of the instructor that earns that salary?
SELECT name FROM instructor WHERE dept_name   =   'Statistics' order by salary asc limit 1
name of the instructor refers to SELECT name; that earns that salary within a specific department ('Statistics') refers to WHERE dept_name = 'Statistics'; ordering by salary in ascending order and selecting the first result refers to ORDER BY salary ASC LIMIT 1