Question: SHOW SQL CODE WITH OUTPUT Question 6: I 1. Consider the following table: Order_Detail Orderno Custno Item Qty Amount A001 C003 Burger 3 60 A002

SHOW SQL CODE WITH OUTPUT

SHOW SQL CODE WITH OUTPUT Question 6: I 1. Consider the following

Question 6: I 1. Consider the following table: Order_Detail Orderno Custno Item Qty Amount A001 C003 Burger 3 60 A002 C001 Pizza 2 300 A003 C005 Burger 5 100 A004 C004 Burger 5 100 A005 C001 Hot- 2 40 dog Customer Custno name Address city Phone C001 George | NV Delhi 6199408 C002 Ashok Arawali Delhi 6129400 C003 Raman DB Delhi 6133888 Road C004 James Puna Delhi 6144218 C005 Patrick Bihar Delhi 6111228 a) Write a query to display name of the customer who paid the maximum amount. b) Write a query to update customer data by changing its phone number with a new number obtained by prefixing old phone by 2 i.e., 26199408. c) Write a procedure for get the Item as input and print the total amount ordered

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!