Hi, could you please let me know the name of instructors in Comp. Sci. department whose salary is higher than 80000?
select name from instructor where dept_name = 'Comp. sci.' and salary > 80000
Oh only two of them. Thank you :) Then could you please let me  know the name of the instructor whose salary is the highest in the table?
select name from instructor order by salary desc limit 1
That was quick, thank you again. Then could you please tell me the department name of instructor Wieland?
select dept_name from instructor where name = "Wieland"
Thank you :) If it is not too bothersome, could you please let me know the average salary of the instructors in Pol. Sci.?
select avg ( salary ) from instructor where dept_name = "Pol. sci."
Thank you, then could you please tell me what would be the average salary of instructors for Cybernetics?
select avg ( salary ) from instructor where dept_name = "Cybernetics"
Thank you :) This will be my last question, could you please let me know the name and ID of the instructor whose salary is the lowest?
select name, id from instructor order by salary asc limit 1