Show the name for all employees.
select name from employee
Also show their salaries.
select name, salary from employee
Order the results by their salary.
select name, salary from employee order by salary