KyleCole01 · KyleCole01 · Jun 10, 2019
diff --git a/README.md b/README.md
@@ -16,46 +16,67 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
 
 ### **Clicking the `Restore Database` button in the page will repopulate the database with the original data and discard all changes you have made**.
 
-### find all customers that live in London. Returns 6 records.
+### (1) find all customers that live in London. Returns 6 records.
 > This can be done with SELECT and WHERE clauses
 
-### find all customers with postal code 1010. Returns 3 customers.
+SELECT * FROM [Customers] WHERE City = 'London'
+
+### (2) find all customers with postal code 1010. Returns 3 customers.
 > This can be done with SELECT and WHERE clauses
 
-### find the phone number for the supplier with the id 11. Should be (010) 9984510.
+SELECT * FROM [Customers] WHERE PostalCode = 1010
+
+### (3) find the phone number for the supplier with the id 11. Should be (010) 9984510.
 > This can be done with SELECT and WHERE clauses
 
-### list orders descending by the order date. The order with date 1997-02-12 should be at the top.
+SELECT Phone FROM Suppliers WHERE SupplierID = 11
+
+### (4) list orders descending by the order date. The order with date 1997-02-12 should be at the top.
 > This can be done with SELECT, WHERE, and ORDER BY clauses
 
-### find all suppliers who have names longer than 20 characters. You can use `length(SupplierName)` to get the length of the name. Returns 11 records.
+SELECT * FROM Orders ORDER BY OrderDate DESC
+
+### (5) find all suppliers who have names longer than 20 characters. You can use `length(SupplierName)` to get the length of the name. Returns 11 records.
 > This can be done with SELECT and WHERE clauses
 
-### find all customers that include the word "market" in the name. Should return 4 records.
+SELECT SupplierName FROM Suppliers WHERE LENGTH(SupplierName)>20
+
+### (6) find all customers that include the word "market" in the name. Should return 4 records.
 > This can be done with SELECT and a WHERE clause using the LIKE keyword
 
 > Don't forget the wildcard '%' symbols at the beginning and end of your substring to denote it can appear anywhere in the string in question
 
-### add a customer record for _"The Shire"_, the contact name is _"Bilbo Baggins"_ the address is _"1 Hobbit-Hole"_ in _"Bag End"_, postal code _"111"_ and the country is _"Middle Earth"_.
+SELECT * FROM Customers WHERE CustomerName LIKE "%market%"
+
+### (7) add a customer record for _"The Shire"_, the contact name is _"Bilbo Baggins"_ the address is _"1 Hobbit-Hole"_ in _"Bag End"_, postal code _"111"_ and the country is _"Middle Earth"_.
 > This can be done with the INSERT INTO clause
 
-### update _Bilbo Baggins_ record so that the postal code changes to _"11122"_.
+INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ("The Shire","Bilbo Baggins", "1 Hobbit-Hole", "111","Bag End", "Middle Earth")
+
+### (8) update _Bilbo Baggins_ record so that the postal code changes to _"11122"_.
 > This can be done with UPDATE and WHERE clauses
 
-### list orders grouped by customer showing the number of orders per customer. _Rattlesnake Canyon Grocery_ should have 7 orders.
+UPDATE Customers SET PostalCode = "11122" WHERE ContactName = "Bilbo Baggins"
+
+### (9) list orders grouped by customer showing the number of orders per customer. _Rattlesnake Canyon Grocery_ should have 7 orders.
 > This can be done with SELECT, COUNT, JOIN and GROUP BY clauses. Your count should focus on a field in the Orders table, not the Customer table
 
 > There is more information about the COUNT clause on [W3 Schools](https://www.w3schools.com/sql/sql_count_avg_sum.asp)
 
-### list customers names and the number of orders per customer. Sort the list by number of orders in descending order. _Ernst Handel_ should be at the top with 10 orders followed by _QUICK-Stop_, _Rattlesnake Canyon Grocery_ and _Wartian Herkku_ with 7 orders each.
+SELECT customername, count(*) as 'Number of Orders' FROM orders LEFT JOIN customers ON orders.customerid = customers.customerid GROUP BY orders.customerid
+
+
+### (10) list customers names and the number of orders per customer. Sort the list by number of orders in descending order. _Ernst Handel_ should be at the top with 10 orders followed by _QUICK-Stop_, _Rattlesnake Canyon Grocery_ and _Wartian Herkku_ with 7 orders each.
 > This can be done by adding an ORDER BY clause to the previous answer
 
-### list orders grouped by customer's city showing number of orders per city. Returns 58 Records with _Aachen_ showing 2 orders and _Albuquerque_ showing 7 orders.
+SELECT customername, count(*) as Num_Of_Orders FROM orders LEFT JOIN customers ON orders.customerid = customers.customerid GROUP BY orders.customerid ORDER BY Num_Of_Orders DESC
+
+### (11) list orders grouped by customer's city showing number of orders per city. Returns 58 Records with _Aachen_ showing 2 orders and _Albuquerque_ showing 7 orders.
 > This is very similar to the previous two queries, however, it focuses on the City rather than the CustomerName
 
 ## Stretch Goals
 
-### delete all customers that have no orders. Should delete 17 (or 18 if you haven't deleted the record added) records.
+### (12) delete all customers that have no orders. Should delete 17 (or 18 if you haven't deleted the record added) records.
 > This is done with a DELETE query
 
 > In the WHERE clause, you can provide another list with an IN keyword this list can be the result of another SELECT query. Write a query to return a list of CustomerIDs that meet the criteria above. Pass that to the IN keyword of the WHERE clause as the list of IDs to be deleted
@@ -77,3 +98,40 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
   - the `id` should be the primary key for the table.
   - account `name` should be unique.
   - account `budget` is required.
+
+ # Commands
+  _______________________________________________________________________
+ > 1.) SELECT * FROM [Customers] WHERE City = 'London'
+
+
+ > 2.) SELECT * FROM [Customers] WHERE PostalCode = 1010
+
+
+ > 3.) SELECT Phone FROM Suppliers WHERE SupplierID = 11
+
+
+ > 4.) SELECT * FROM Orders ORDER BY OrderDate DESC
+
+
+ > 5.) SELECT SupplierName FROM Suppliers WHERE LENGTH(SupplierName)>20
+
+
+ > 6.) SELECT * FROM Customers WHERE CustomerName LIKE "%market%"
+
+
+ > 7.) INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ("The Shire","Bilbo Baggins", "1 Hobbit-Hole", "111","Bag End", "Middle Earth")
+
+
+ > 8.) UPDATE Customers SET PostalCode = "11122" WHERE ContactName = "Bilbo Baggins"
+
+
+ > 9.) SELECT customername, count(*) as 'Number of Orders' FROM orders LEFT JOIN customers ON orders.customerid = customers.customerid GROUP BY orders.customerid
+
+
+ > 10.) SELECT customername, count(*) as Num_Of_Orders FROM orders LEFT JOIN customers ON orders.customerid = customers.customerid GROUP BY orders.customerid ORDER BY Num_Of_Orders DESC
+
+
+ > 11.) SELECT city, count(*) as Num_Of_Orders FROM orders LEFT JOIN customers ON orders.customerid = customers.customerid GROUP BY customers.city ORDER BY city
+
+
+ > 12.) DELETE FROM Customers WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders)