9. Display the product with the most total sales amount (sale amount = price*quantity, total sales amount = sum of sale amount in all the orders). For example, if iPhone12 (price = 10) was sold in two orders for amount of 3 and 1 respectively, then the total sales amount = 10 * 3 + 10 * 1 = 40. If there is a tie, display all of them. An example output (there is a tie in this example): product_name total_sales_amount iPhone 12 30000 iPhone 13 30000
9. Display the product with the most total sales amount (sale amount = price*quantity, total sales amount = sum of sale amount in all the orders). For example, if iPhone12 (price = 10) was sold in two orders for amount of 3 and 1 respectively, then the total sales amount = 10 * 3 + 10 * 1 = 40. If there is a tie, display all of them. An example output (there is a tie in this example): product_name total_sales_amount iPhone 12 30000 iPhone 13 30000
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Need help writing SQL queries for sample data base
Transcribed Image Text:Write SQL queries for the following database:
Customers
Orders
id
id
to
FOrder_Product
customer_id
name
id
email
K order_id
product_id
Products
Categories
id
|quantity
id
to
name
category_id
name
price
Transcribed Image Text:9. Display the product with the most total sales amount (sale amount = price*quantity,
total sales amount = sum of sale amount in all the orders). For example, if iPhone12
(price = 10) was sold in two orders for amount of 3 and 1 respectively, then the total sales
amount = 10 * 3 + 10 * 1 = 40. If there is a tie, display all of them. An example output
(there is a tie in this example):
product_name
total_sales_amount
iPhone 12
30000
iPhone 13
30000
10. Display all categories and the most expensive product in them. If multiple products in
the same category tie as the most expensive product in that category, display all of them
(see iPhone 12 and iPhone 13 in the example below). Note that categories with no
products also need to be listed, with null product columns. An example output:
most_expensive_
product_name
The Wealth of
category_name
price
Books
99.48
Nations
Phones
iPhone 12
1199.00
Phones
iPhone 13
1199.00
Clothes
NULL
NULL
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY