Who is the instructor of the statistics department?
select name from instructor where dept_name = "Statistics"
What is their average salary?
select avg ( salary ) from instructor where dept_name = "Statistics"
Who in the statistics department has the highest salary?
select name from instructor where dept_name = "Statistics" order by salary desc limit 1
How much is his salary?
select salary from instructor where dept_name = "Statistics" order by salary desc limit 1