what is the highest salary?
select max ( salary ) from instructor
what is the salary of instructor in math department?
select t2.salary from advisor as t1 join instructor as t2 on t1.i_id = t2.id join student as t3 on t1.s_id = t3.id where t3.dept_name = 'Math'
what is McKinnon salary?
select salary from instructor where name = 'McKinnon'
what department is McKinnon?
select dept_name from instructor where name = 'McKinnon'