Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write Sql commands for following customer and order table: (DBMS): Write a query to display name of items having maximum price. Write a query to

Write Sql commands for following  customer and order table:

(DBMS):

  • Write a query to display name of items having maximum price.
  • Write a query to calculate total no of orders placed by Ali and Junaid.
  • Write a query to list name of all customers who either have placed order or not.
  • Write a query to calculate average quantity of items by item wise.


Cust_ID
Name
 City

1
Ali
Karachi

2
Waqar
Lahore

 3
Junaid
Hyd

4
Irfan
ISB

5
Zain
Multan

Order_ID
Item
Price
Quantity
Cust_ID
1
pizza
1500
2
1
2
burger
800
1
1
3
pizza
450
3
3
4
Fries
250
2
3
5
soda
100
3
4

Step by Step Solution

3.40 Rating (144 Votes )

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

Document Format ( 2 attachments)

PDF file Icon
636ad455b7d92_243319.pdf

180 KBs PDF File

Word file Icon
636ad455b7d92_243319.docx

120 KBs Word File

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

Students also viewed these Databases questions

Question

What is an open source DBMS?

Answered: 1 week ago