![alisucaalisuca](/avatars/26398.jpg)
alisucaalisuca
27.02.2020 •
Computers and Technology
Write a SELECT statement that uses an aggregate window function to get the total amount of each order. Return these columns: The order_id column from the Order_Items table The total amount for each order item in the Order_Items table (Hint: You can calculate the total amount by subtracting the discount amount from the item price and then multiplying it by the quantity) The total amount for each order Sort the result set in ascending sequence by the order_id column.
Solved
Show answers
More tips
- S Style and Beauty How to Make Your Lips Fuller? Ideas and Tips for Beautiful Lips...
- C Computers and Internet How to Learn to Type Fast?...
- A Art and Culture Who Said The Less We Love a Woman, the More She Likes Us ?...
- F Family and Home Parents or Environment: Who Has the Most Influence on a Child s Upbringing?...
- H Health and Medicine Is it true that working with a computer is harmful to your eyesight?...
- H Health and Medicine Boosting Immunity: A Complete Guide on How to Improve Your Body’s Natural Defenses...
- P Philosophy Unidentified Flying Object - What is the Nature of this Phenomenon?...
- C Computers and Internet How to Teach Older Generations to Work with Computers?...
- G Goods and services How to Choose a Coffee Maker? The Ultimate Guide for Coffee Lovers...
- C Computers and Internet Porn Banner: What It Is and How to Get Rid Of It?...
Answers on questions: Computers and Technology
- C Computers and Technology Only those who are considered book smart can be called intelligent...
- C Computers and Technology Why would you want to export access data to excel before using it in another application, such as powerpoint or word?...
- C Computers and Technology The control panel is the window that provides to the computer settings and functions that a user needs to control....
- B Biology Aregistered nurse is teaching a nursing student about healthcare effectiveness data and information set (hedis). which point mentioned by the student post-teaching needs...
- B Biology Mrs. thorne has a subarachnoid hemorrhage (sah) which may be a result of bleeding from a cerebral aneurysm. you know that sah resulting from a cerebral aneurysm is characterized...
- M Mathematics The distance between mike’s house and the grocery store is 4/5 of a mile. mike has walked 1/2 of a mile from his house to the grocery store. how much farther does he needs...
- M Mathematics Abookstore bought a case of 10 books at a wholesale price of $84. the bookstore will sell the books at a 25 percent markup, and each book will be sold for the same amount....
- M Mathematics Suppose you inherited $275,000 and invested it at 8.25% per year. how much could you withdraw at the beginning of each of the next 20 years? $23,788.03 $22,598.63 $25,040.03...
- B Business Organizations are moving toward more development approaches, seeking to improve not only the functionality of the systems they have in place, but consumer confidence in...
- E English There the woods of spring are a-bloom, and the fragrant scent “he is i” is borne on the wind: there the bee of the heart is deeply immersed, and desires no other joy. in...
Ответ:
Answer alongwith Explanation:
The following is the statement that uses an aggregate window function in order to get the total amount of each order.
SELECT isnull(p1.PName,'Total') As PName,
Sum((t1.Price minus t1.Discount ) multiply with Quantity) AS TotalAmount
FROM Products AS t1
JOIN OrderItems AS t2
ON t1.ProductID = t2.ProductID
GROUP BY Rollup(PName) ORDER BY order id ASC
Thus, it can be used for the function.
Ответ:
I prefer richtofen P.S the medics father like its a fact
Explanation:
But probably Aristole