Consider the following table FITNESS with details about fitness products being sold in the store. Write command of SQL for (i) to (iv) and output for (v) to (viii).
Table : FITNESS
PCODE |
PNAME |
PRICE |
MANUFACTURER |
P1 |
Treadmill |
21000 |
Coscore |
P2 |
Bike |
20000 |
Aone |
P3 |
Cross Tiainer |
14000 |
Reliable |
P4 |
Multi Gym |
34000 |
Coscore |
P5 |
Massage Chair |
5500 |
Regrosene |
P6 |
Belly Vibrator Belt |
6500 |
Ambaway |
(i) To display the names of all the products with price more than 20000.
(ii) To display the names of all the products by the manufacturer "Aone".
(iii) To change the price data of all the products
by applying 25% discount reduction.
(iv) To add a new row for product with details: "P7","Vibro Exerciset", 28000,'Aone".
(V) SELECT * FROM FITNESS WHERE MANUFACTURERNAME, LIKE " % e" .
(vi) SELECT COUNT((DISTINCT)MANUFACTURER) FROM FITNESS.
(vii) SELECT MAX(PRICE) FROM FITNESS.