1. SElECT * FROM states;
2. SELECT * FROM regions;
3. SELECT DISTINCT state_name, population
   ...> FROM states;
4. SELECT DISTINCT state_name, population
   ...> FROM states
   ...> ORDER BY population DESC;
5. SELECT state_name FROM states
   ...> WHERE region_id = 7;
6.SELECT state_name, population_density
   ...> FROM states
   ...> ORDER BY population_density ASC;
7. SELECT state_name FROM states
   ...> WHERE population BETWEEN 1000000 AND 1500000;
8.SELECT state_name, region_id FROM states
   ...> ORDER BY region_id ASC;
9. SELECT region_name FROM regions
   ...> WHERE region_name LIKE '%central%';
10. SELECT regions.region_name, states.state_name
   ...> FROM regions
   ...> INNER JOIN states
   ...> on regions.id = states.region_id;

![image](https://raw.githubusercontent.com/cguard90/cguard90.github.io/master/imgs/SCHEMA.png)

Add file for 8.4 with image
Add file for 8.4 with image
