Show the salaries for all employees.
select salary from employee
What is the average of them?
select avg(salary) from employee
Show the name for all employees with a salary above that.
select name from employee where salary > (select avg(salary) from employee)