Question: Write a query that will show all ordered items, their descriptions, regular prices, discounts and total price per order: In the example below the discount

Write a query that will show all ordered items, their descriptions, regular prices, discounts and total price per order:

In the example below the discount is 5%

orderID

itemID

itemDescription

itemPrice

Ordered quantity

Discount per item

Total order

1

1111

Side Table

$1599.99

2

$80

$3039.98

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!

Q:

Hi, I need assistance with this Access homework. The one already posted is missing steps. Project Description: Northwind Traders, an international gourmet food distributor, hired a new CEO. She asked...

Q:

Step Instructions Point Value 1 Start Access. Open the downloaded Access file named exploring_a03_Grader_h1. 0 2 Create a query using Query Design. The customer's table includes CompanyName,...

Q:

Please, I need help with the calculations for the following 25 problems in the "final" tab of the workbook before 9pm CST. FINC 340 Quizzes 1 2 Derivatives can be strictly defined as Financial...

Q:

What operational changes would you recommend to Wally to improve performance? Wally Meyer deftly balanced his office keys and a large printout of forecasting data as he wheeled his mountain bike...

Q:

QUESTION: Begin by preparing your SWOT analysis to get a core understanding of where Amazon and Walmart were as companies in 2017. AMAZON AND WALMART ON COLLISION COURSE (CASE A) AMAZON AND WALMART...

Q:

Case Questions: Be Our Guest, Inc. 1. A. Reformat the income statement to clearly indicate EBITDA and EBIT. B. See footnote A Exhibit 3. Remove from "Other General and Administrative Expenses the...

Q:

Please complete the following reports for "kohl's 2017 financial statement" note that the suggested reports have numbers filled in but they do not relate. (Ignore where it says JCPenney on top of the...

Q:

can any expert help me to work on the questions below?? i need it done correctly as soon as possible FINC 340 Quizzes 1 2 Derivatives can be strictly defined as Financial intermediaries are extremely...

Q:

Assume that a restaurant offers the following breakfast items: Plain Egg $1.45 Bacon and Egg $2.45 Muffin $0.99 French Toast $1.99 Fruit Basket $2.49 Cereal $0.69 Coffee $0.50 Tea $0.75 Write a...

Q:

OUTPUT1.TXT: Assume that a restaurant offers the following breakfast items Plain Egg Bacon and Egg Muffin French Toast Fruit Basket Cereal Coffee Tea $1.45 $2.45 $0.99 $1.99 $2.49 $0.69 $0.50 $0.75...

Q:

There is currently a highly competitive labour market for clerical workers in Edinburgh with no union representation. They are considering voting to have a union represent them in negotiations with...

Q:

Describe at least two products or production processes that might use both process and job order costing methods to determine the cost of a finished unit.

Q:

A family has a net worth of $ 1 5 4 , 0 0 0 and liabilities of $ 1 6 4 , 0 0 0 . What is the amount of their assets?

Q:

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

Q:

How are Work Breakdown Statements Built and how do they appear in a Project Plan?

Q:

What is the most important part of any HCM Project Map and why?

Q:

What is the Phase that begins after Project rollover and what activities are part of the Phase?