Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started