Reference no: EM13166883
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.
2. Write a SELECT statement that returns these columns from the CustomerAddresses view that you created in exercise 1: CustomerID, LastName, FirstName, BillLine1.
3. 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.
4. 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.
5. Create a view named ProductSummary that uses the view you created in exercise 4. 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).
6. Write a SELECT statement that uses the view that you created in exercise 5 to get total sales for the five best selling products.
|
What is the mass of the liquid left over
: There is 12.0 g CCl3F in a 1.1 L container at 856 torr and 300 K. What is the mass of the liquid left over?
|
|
Write the definition of a method
: Write the definition of a method , isReverse , whose two parameters are arrays of integers of equal size. The method returns true if and only if one array is the reverse of the other. ("Reverse" here means same elements but in reverse order.)
|
|
What volume of the liquid should he use
: An experiment requires 40.0 of ethylene glycol, a liquid whose density is 1.114 . Rather than weigh the sample on a balance, a chemist chooses to dispense the liquid using a graduated cylinder. What volume of the liquid should he use?
|
|
List the basic solutions in order of increasing basicity
: List the basic solutions in order of increasing basicity. NH2OH, HNO2, C2H5NH2, NaNO2, and Ca(OH)2
|
|
Write a select statement
: Write a SELECT statement that returns these columns from the CustomerAddresses view that you created in exercise 1: CustomerID, LastName, FirstName, BillLine1.
|
|
Calculate the fraction of atoms in a sample of argon gas
: Calculate the fraction of atoms in a sample of argon gas at 400K that have an energy of 10.0 KJ or greater.
|
|
Integers as a parameter and returns the number
: Write a method maxOccurrences that accepts a list of integers as a parameter and returns the number the number of times the most frequently occurring integer
|
|
Draw lewis structures for the following five elements
: draw Lewis Structures for the following FIVE elements.
|
|
How many pills does the patient need to take each time
: A patient needs to take 375 mg of ibuprofen twice daily. The pills in the bottle are each 250. rm mg. How many pills does the patient need to take each time she wants the 375 mg dosage? Assume that these pills are scored and can be cut in half if ..
|