********* PART 1 ***********
SELECT COUNT(*) FROM users;
answer: 50;


******** PART 2 ************
SELECT * FROM items ORDER BY price 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


******** PART 3 ************
SELECT * FROM items WHERE catergory = 'books';
answer:
4|Fantastic Steel Chair|Books|Advanced attitude-oriented encryption|9246
21|Fantastic Rubber Shoes|Books|Reverse-engineered modular hierarchy|8904
76|Ergonomic Granite Chair|Books|De-engineered bi-directional portal|1496
98|Practical Plastic Hat|Books|Implemented non-volatile model|3056

SELECT * FROM items WHERE category LIKE '%books%';
answer:
4|Fantastic Steel Chair|Books|Advanced attitude-oriented encryption|9246
12|Fantastic Rubber Shirt|Toys & Books|Ergonomic impactful emulation|6720
21|Fantastic Rubber Shoes|Books|Reverse-engineered modular hierarchy|8904
60|Ergonomic Steel Car|Books & Outdoors|Enterprise-wide secondary firmware|9341
76|Ergonomic Granite Chair|Books|De-engineered bi-directional portal|1496
77|Fantastic Plastic Gloves|Beauty, Movies & Books|Robust bandwidth-monitored local area network|6584
95|Small Cotton Hat|Beauty & Books|Reduced regional instruction set|1727
97|Incredible Granite Computer|Books, Toys & Tools|De-engineered national policy|2377
98|Practical Plastic Hat|Books|Implemented non-volatile model|3056
100|Awesome Granite Pants|Toys & Books|Upgradable 24/7 access|9790

SELECT * FROM items WHERE category = 'Books' ORDER BY price LIMIT 1;
answer:
76|Ergonomic Granite Chair|Books|De-engineered bi-directional portal|1496


********* PART 4 *********
SELECT * FROM addresses WHERE street = '6439 Zetta Hills';
result:
43|40|6439 Zetta Hills|Willmouth|WY|15029

SELECT * FROM users WHERE id = "40";
result:
40|Corrine|Little|rubie_kovacek@grimes.net

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


********* PART 5 *********
SELECT * FROM users WHERE first_name = 'Virginie';
answer:
39|Virginie|Mitchell|daisy.crist@altenwerthmonahan.biz

SELECT * FROM addresses WHERE user_id = '39';
answer:
41|39|12263 Jake Crossing|New York|NY|10108
42|39|83221 Mafalda Canyon|Bahringerland|WY|24028

UPDATE addresses SET zip = '12345' WHERE id = '41';
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


******** PART 6 *********
SELECT SUM(quantity) FROM orders;
answer:
2125


********** PART 7 ************
INSERT INTO users (id, first_name, last_name, email) VALUES ('51', 'Alexander', 'Thomas', 'aletho24@gmail.com');
INSERT INTO orders (id, user_id, item_id, quantity, created_at) values ('378', '51', '69', '420', '2017-01-18 16:00:27.123462');