6. Display the calculated total amount for Order 103 (Orders.id = 103). How to calculate the total amount: for example, if an order purchased 1 iPhone and 3 iPads, then the total for that order would be 1 * iPhone_price + 3 * iPad_price. 7. Display all customers with the number of orders they placed. Note that customers with no purchase also need to be listed. An example output: customer_name number_of_orders John 7 Anna Mia 3
6. Display the calculated total amount for Order 103 (Orders.id = 103). How to calculate the total amount: for example, if an order purchased 1 iPhone and 3 iPads, then the total for that order would be 1 * iPhone_price + 3 * iPad_price. 7. Display all customers with the number of orders they placed. Note that customers with no purchase also need to be listed. An example output: customer_name number_of_orders John 7 Anna Mia 3
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:6. Display the calculated total amount for Order 103 (Orders.id = 103). How to calculate
the total amount: for example, if an order purchased 1 iPhone and 3 iPads, then the total
for that order would be 1 * iPhone_price + 3 * iPad_price.
7. Display all customers with the number of orders they placed. Note that customers with
no purchase also need to be listed. An example output:
customer_name
number_of_orders
John
7
Anna
Mia
3
Expert Solution
Step 1
6. SELECT order_id, SUM(price) AS total amount
FROM Order O, Order_product OP, Products P, customer C, categories CT
WHERE C.id = O.customer_id AND O.id = OP.order_id AND CT.id = P.category_id AND P.category_id = OP.product_id
GROUP BY OP.order_id
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