Question: NOTE: Written in SQL Express. Using MyGuitarShop database. Orders Table: PK. OrderId, FK CustomerID OrderItems Table: PK. ItemID, FK OrderID, FK ProductID, Columns: ItemPrice, DiscountAmount,

NOTE: Written in SQL Express. Using "MyGuitarShop database".

Orders Table:

PK. OrderId, FK CustomerID

OrderItems Table:

PK. ItemID, FK OrderID, FK ProductID, Columns: ItemPrice, DiscountAmount, Quantity.

1. Write a script that uses three variables to store (1) the count of distinct orders made in the Orders table (2) the total amount of sales (sales means the price of the item with discount multiplied by the quantity) made in the OrderItems table and (3) the average sales calculated using the first two variables ($843.3). Dont include TaxAmount or shipping costs.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SQL Assignment. TIA SQL Table How to code subqueries Exercises 1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in...

MySQL Q.6) (25 points) You have been notified that Fender Guitars has discontinued their 'Fender Stratocaster' Guitar and that you will no longer carry it in your inventory. As a result, you need to...

MySQL help Q.6) (25 points) You have been notified that Fender Guitars has discontinued their 'Fender Stratocaster' Guitar and that you will no longer carry it in your inventory. As a result, you...

/* Query 4. This query requires you to write two SELECT statements described below. Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer....

MyQSL Q.6) (15 points) Write a DELETE statement that deletes the row that you added to the addresses table in Question 2 above. Note that deleting the address record that was added in Q2 will leave...

myQSL Q.1) (15 points) Write 2 queries to create copies of the addresses and orders tables. Name them address_copy and order_copy To allow for repeated clean executions of your script, precede the...

\ -- Chapter 5 Homework Insert, update, and delete data Use your copy of the my_guitar_shop database: _mgs If you need to restore the database to the original state, you can modify and run the...

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

In our Canvas Shell, go to CSD - 1 3 8 Resources \ Book Resources ( including scripts to setup our databases etc. ) to download and the file create _ my _ guitar _ shop.sql Then to run the file o...

Assume that Wal-Mart Stores, Inc. has decided to surface and maintain for 10 years a vacant lot next to one of its stores to serve as a parking lot for customers. Management is considering the...

According to the local union president, the mean gross income of plumbers in the Salt Lake City area follows the normal probability distribution with a mean of $45,000 and a standard deviation of...

You would like to buy a house that costs $ 3 7 0 comma 0 0 0 3 7 0 , 0 0 0 . You have $ 5 0 comma 0 0 0 5 0 , 0 0 0 in cash that you can put down on the house, but you need to borrow the rest of the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How would redundant storage of values in columns in a Table be eliminated?

What do Primary Keys, along with Third Normal Form Design in a Database Model, achieve?

Describe Table Structures in RDMSs.