Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

5. Have you any experience with agile software development?

Answered: 1 week ago