SQL Bootcamp
-
-
-
Create a SQL file called Practice1.sql. Then, complete the following:
Select all columns from the table Customers.
Select AddressID, AddressLine1, AddressLine2, City, and StateProvince from the Address table where the StateProvince is Missouri.
Select the unique cities from the Address table where the StateProvince is Missouri.
Select the first name, last name, and company name of the unique customers in the Customers table whose company name has the word Bike in it.
-
The Situation: AdventureWorks just had a product recall on their "Sport-100 Helmet, Black" product. We have to move fast to fix the problem!
Your manager sends you the following email:
Hey team, looks like our vendor recalled those black helmets we shipped out. We need to find out who ordered them and send out the replacement helmets the vendor sent us.
We'll be reimbursed for shipping and the cost of the helmets, but any discount rate is on us. Can you send me the full name, company name, address, and number of the black helmets ordered? I’ll also need to know the discount we’re losing for each.
Your manager is counting on you, so make sure to get them the information!
Small hints:
The discount rate is in decimal form, so 5% would be 0.05. The money lost would be the discount rate multiplied by the cost of the items, not what the customer paid.
The product is listed as "Sport-100 Helmet, Black".
-
-
-
-
