7. Consider the following table named "GYM" with details about 6
Fitness products being sold in the store.
Table Name : GYM
PrCode stores Codes of Products
PrName stores names of Products (UnitPrice is in Rs.)
PrCode PrName
Unit Price Manufacturer
P101
Cross Trainer
25000
Avon Fitness
P102
Treadmill
32000
AG Fitline
P103
Massage Chair
20000
Fit Express
P104
Vibration Trainer
22000
Avon Fitness
P105 Bike
13000 Fit Express
Write SQL statements to do the following:
a. Display the names and unit price of all the products in the store.
b. Display the names of all the products with unit price less than
Rs.20000.00
c. Display details of all the products with unit price in the range 20000
to 30000.
d. Display names of all products by the manufacturer "Fit Express".
e. Change the Unit Price data of all the rows by applying a 10% discount
reduction on all the products.
f. Display details of all products with manufacturer name starting with
Answers
Answered by
1
Answer:
123446788 I don't know if you can get a good result in the future
Similar questions