What is average and maximum salary of all employees.
select avg ( salary ), max ( salary ) from employee
What name has the highest salary?
select name from employee order by salary desc limit 1
What is the employee id and salary of George Wright?
select eid, salary from employee where name = "George Wright"
What is the name and employee id of the person with the lowest salary
select name, eid from employee order by salary limit 1