SQL -- Use MyGuitarShop

>>> Write a SELECT statement that joins the Categories table to the Products table and shows these columns: CategoryName, ProductName, ListPrice.

Sort the result set by CategoryName and then by ProductName in ascending order.

>>> Write a SELECT statement that joins the Customers table to the Addresses table and shows these columns: FirstName, LastName, Line1, City, State, ZipCode.

Display the shipping and billing addresses for the customer with an email address of allan.sherwood@yahoo.com.

>>> Write a SELECT statement that joins the Customers table to the Addresses table and shows these columns: FirstName, LastName, Line1, City, State, ZipCode.

Display only the shipping address of the customers. Your result should not show the billing address.

>>> Write a SELECT statement that joins the Customers, Orders, OrderItems, and Products tables. This statement should show these columns: LastName, FirstName, OrderDate, ProductName, ItemPrice, DiscountAmount, and Quantity.

Use aliases for the tables.

Show only those rows where the customer LastName starts with an R or W.

Sort the final result set by LastName, OrderDate, and ProductName.

>>> Write a SELECT statement that joins the Customers, Orders and OrderItems, and Products tables. This statement should show these columns: LastName, FirstName, ProductName, ItemPrice, DiscountAmount, Quantity, DiscountItemPrice which is the price of an item subtracted from the discount, and TotalItemPrice which is discounted item price multiplied by Quantity.

Show the products that did not have a discount

Sort the result set by LastName and ProductName

>>> Write a SELECT statement that shows these two columns:

CategoryName The CategoryName column from the Categories table

ProductID The ProductID column from the Products table

Show one row for each category that has never been used. Hint: Use an outer join

data:

Use MyGuitarShop SelectFrom Customers 100% EEE Results Messages CustomerlD Email Address Password First Name LastName ShippingAddressID BillingAddressID allan.sherwood@yahoo.com 650215acc746f0e 32bdifff387439eefc 1358737 Allan Sherwood 1 Zimmer 3 bamyz@gmail.com christineb@solarone.com david.goldstein@hotmail.com b444ac06613fc8d63795be9adObeaf55011936ac David erinv@gmail.com frankwilson@sbcglobalnet 3ebfa301dc59196f 18593c45e519287a23297589 Frank Lee n 8 gary hemandez@yahoo.com Iff 2b3704aede04eecb51e50ca698efd50a 1379b Gary heatheresway@mac.com 31563468d42a448cb le56924529f6e7bbe529cc7 Bary ed19f5c0833094026a21e9e6f08a35d26037066 Christine Brown Goldstein 5 Valentino7 109f4b3c50d 7bOdf 729d299bc6f8e 9ef9066971f Erin 7 Hemandez 9 10 12 911ddc3b 8f9a 13b5499b6bc4638a2b4f3f68bf23 Heather Esway Use MyGuitarShop SelectFrom Customers 100% EEE Results Messages CustomerlD Email Address Password First Name LastName ShippingAddressID BillingAddressID allan.sherwood@yahoo.com 650215acc746f0e 32bdifff387439eefc 1358737 Allan Sherwood 1 Zimmer 3 bamyz@gmail.com christineb@solarone.com david.goldstein@hotmail.com b444ac06613fc8d63795be9adObeaf55011936ac David erinv@gmail.com frankwilson@sbcglobalnet 3ebfa301dc59196f 18593c45e519287a23297589 Frank Lee n 8 gary hemandez@yahoo.com Iff 2b3704aede04eecb51e50ca698efd50a 1379b Gary heatheresway@mac.com 31563468d42a448cb le56924529f6e7bbe529cc7 Bary ed19f5c0833094026a21e9e6f08a35d26037066 Christine Brown Goldstein 5 Valentino7 109f4b3c50d 7bOdf 729d299bc6f8e 9ef9066971f Erin 7 Hemandez 9 10 12 911ddc3b 8f9a 13b5499b6bc4638a2b4f3f68bf23 Heather Esway