yes
select name from instructor where dept_name = 'Statistics'
show the total no. of ID
select count ( id ) from instructor
what is the salary of the the ID 78699
select salary from instructor where id = 78699
what is the dept. name of the 	McKinnon
select dept_name from instructor where name = 'McKinnon'