Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID) In a shopping store, one customer can place order many times. Shopping store's managerwants to see maximum order of every customer in following format. Write a SQL queryto present this data. [Hine: Use Order Table]vii.CustIDMaximum Orderviii.Write a SQL query to display all products whose price is more than "Bread' price.Write a SQL query to show all order ids, order price and customer names who took thatix.order in ascending order.

here have to determine about sql query for given problem.

Answered: llowing tables support the database of…

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

See similar textbooks

Related questions

Question

Following tables support the database of a shopping store. The schema contains four tables i.e.
Customer, Product, Order and Order Product. Table details including attributes, primary keys
(underline) and foreign keys (bold) are also shown below:
CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)
PRODUCT(ProdID, ProdName, ProdPrice)
ORDER(OrderID, OrderDate, OrderPrice, CustID)
ORDER_PRODUCT(OPID, ProdID, OrderID)