Consider the following database and write SQL as given:

Customer (Cno, Cname, Caddress, Ccontact)

Purchase (Cno, Pid)

Product (Pid, Pname, price, quantity)

a. Find the names of all products having price 1000.

b. Find the name of those customers who purchased Dell Laptop

c. Find the total number of products purchased by customer ‘Ram’

d. Increase price of all products by 5%

e. Find total price of Apple Mobiles.

  • Answered by
  • 0 Comments
  • 2 months ago

This answer is restricted. Please login to view the answer of this question.

Login Now
Leave your Answer:

Click here to submit your answer.

s
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments