SQL Server 2012 Assingment

Assinment MUST be screenshoted, per number. Thats the only way the teacher accepts it. I need this by Friday PLEASE PLEASE dont be late!Chapter 13 How work with views 1.      Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the Customers table: CustomerID, EmailAddress, LastName and FirstName. This view should return these columns from the Addresses table: BillLine1, BillLine2, BillCity, BillState, BillZip, ShipLine1, ShipLine2, ShipCity, ShipState, and ShipZip. (How will you get the billing address and shipping address separately from the Addresses table? Join the Customers table with the Addresses table twice!)Write a SELECT statement that returns these columns from the CustomerAddresses view that you created in exercise 1: CustomerID, LastName, FirstName, BillLine1. 2.      Write an UPDATE statement that updates the CustomerAddresses view you created in exercise 1 so it sets the first line of the shipping address to “1990 Westwood Blvd.” for the customer with an ID of 8. 3.      Create a view named OrderItemProducts that returns columns from the Orders, OrderItems, and Products tables. This view should return these columns from the Orders table: OrderID, OrderDate, TaxAmount, and ShipDate. This view should return these columns from the OrderItems table: ItemPrice, DiscountAmount, FinalPrice (the discount amount subtracted from the item price), Quantity, and ItemTotal (the calculated total for the item). This view should return the ProductName column from the Products table. 4.      Create a view named ProductSummary that uses the view you created in exercise 3. This view should return some summary information about each product. Each row should include these columns: ProductName, OrderCount (the number of times the product has been ordered), and OrderTotal (the total sales for the product). 5.      Write a SELECT statement that uses the view that you created in exercise 4 to get total sales for the fivehighest revenue products (price x quantity).

How to place an order?

Take a few steps to place an order on our site:

  • Fill out the form and state the deadline.
  • Calculate the price of your order and pay for it with your credit card.
  • When the order is placed, we select a suitable writer to complete it based on your requirements.
  • Stay in contact with the writer and discuss vital details of research.
  • Download a preview of the research paper. Satisfied with the outcome? Press “Approve.”

Feel secure when using our service

It's important for every customer to feel safe. Thus, at Your homework help service, we take care of your security.

Financial security You can safely pay for your order using secure payment systems.
Personal security Any personal information about our customers is private. No other person can get access to it.
Academic security To deliver no-plagiarism samples, we use a specially-designed software to check every finished paper.
Web security This website is protected from illegal breaks. We constantly update our privacy management.

Get assistance with placing your order. Clarify any questions about our services. Contact our support team. They are available 24\7.

Still thinking about where to hire experienced authors and how to boost your grades? Place your order on our website and get help with any paper you need. We’ll meet your expectations.

Order now Get a quote