1.  SELECT COUNT(*) FROM users;
    ANSWER: 50

2.  SELECT * FROM items ORDER BY price DESC LIMIT 5;
    ANSWER: 25|Small Cotton Gloves|Automotive, Shoes & Beauty|Multi-layered modular service-desk|9984
            83|Small Wooden Computer|Health|Re-engineered fault-tolerant adapter|9859
            100|Awesome Granite Pants|Toys & Books|Upgradable 24/7 access|9790
            40|Sleek Wooden Hat|Music & Baby|Quality-focused heuristic info-mediaries|9390
            60|Ergonomic Steel Car|Books & Outdoors|Enterprise-wide secondary firmware|9341

3.  SELECT title FROM items WHERE category = 'Books' ORDER BY price LIMIT 1;
    ANSWER: Ergonomic Granite Chair

    SELECT title FROM items WHERE category LIKE '%BOOKS' ORDER BY price LIMIT 1;
    ANSWER: Ergonomic Granite Chair --- no difference

4.  SELECT user_id FROM addresses WHERE street = "6439 Zetta Hills" AND city= "Willmouth" AND state = "WY";
    ANSWER:40
    //THEN GET THE NAME OF ID
    SELECT * FROM users WHERE id = '40';
    ANSWER: 40|Corrine|Little|rubie_kovacek@grimes.net

    SELECT * FROM addresses WHERE user_id = '40';
    ANSWER: 43|40|6439 Zetta Hills|Willmouth|WY|15029
            44|40|54369 Wolff Forges|Lake Bryon|CA|31587

5.  SELECT id FROM users WHERE first_name = 'Virginie' AND last_name = 'Mitchell';
    ANSWER: 39
    //GET ADDRESS
    SELECT * FROM addresses WHERE user_id = '39';
    ANSWER: 41|39|12263 Jake Crossing|New York|NY|12345
42|39|83221 Mafalda Canyon|Bahringerland|WY|24028
    //FIX ADDRESS
    UPDATE addresses SET zip = '12345' WHERE id='41';
    //CHECK ADDRESS TO SEE CHANGE
    SELECT street, city, state, zip FROM addresses WHERE user_id = '39';
    ANSWER:  12263 Jake Crossing|New York|NY|12345
             83221 Mafalda Canyon|Bahringerland|WY|12345

6.  SELECT SUM(quantity) FROM orders;
    ANSWER: 2125

7.  //FIND NEXT ID NUMBER
    SELECT id FROM users;
    //Insert my user
    INSERT INTO users (id, first_name, last_name, email) VALUES ('51', 'Eric','Ransom','eransom97@gmail.com');
    //Find my 'order' data keys
    SELECT * FROM orders;
    //Insert new Order
    INSERT INTO orders (id, user_id, item_id, quantity, created_at) VALUES ('388', '51','97','3','2017-01-10 00:40:31.307668');
    //CHECK new order
    sqlite> SELECT * FROM orders WHERE user_id = '51';
    ANSWER: 388|51|97|3|2017-01-10 00:40:31.307668