Write a script that uses three variables to store

Assignment Help Computer Engineering

Reference no: EM132084323

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.

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).

Don't include TaxAmount or shipping costs.

Reference no: EM132084323

Questions Cloud

How many chairs should the firm order each time : How many chairs should the firm order each time? Assume there is no uncertainty at all about the demand or the lead time.

Compare neural networks and svm techniques : Compare neural networks and SVM techniques. What do they have in common and what are the major differences?

Why is sustaining competitive advantage so difficult : Why are communication skills and first impressions so important? Why is sustaining competitive advantage so difficult?

Create a bmi calculator app that allows users to enter : Create a BMI calculator app that allows users to enter their weight and height and whether they are entering these values in English or metric units.

Write a script that uses three variables to store : 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.

What is the best source for ethical business practices : What is the best source for ethical business practices: The individual employee, or the business organization itself?

What is the purpose of the social security act : What is the purpose of the Social Security Act and how does it affect the compensation of today's employee?

Write a program that has a function prototype : Write a program that has a function prototype before main and an implementation of the function after main.

Create an abstract class vehicle that has the methods : Create a derived class BoatPlane that inherits from Boat that adds the appropriate fields and overloads the appropriate functions.

User Account

All Pages