01

Query all employees from employee

select * 
from employee;

02

Order by employee salary

select * 
from employee
ORDER BY salary;

adding DESC will put largest salary first

select *
from employee
ORDER BY salaray DESC;

03

Get first and last name from employee

select first_name, last_name
from employee;