What are the names of the professors in the Statistics department?
select name from instructor where dept_name = 'Statistics'
Which one earns the least?
select name from instructor where dept_name = 'Statistics' order by salary limit 1