CBSE Class 12 Informatics Practices
Question 15 of 79
MySQL SQL Revision Tour — Question 8
Back to all questions 8
Question Consider the following table FITNESS with details about fitness products being sold in the store. Write command of SQL for (i) to (iv).
Table : FITNESS
| PCODE | PNAME | PRICE | Manufacturer |
|---|---|---|---|
| P1 | Treadmill | 21000 | Coscore |
| P2 | Bike | 20000 | Aone |
| P3 | Cross Trainer | 14000 | Reliable |
| P4 | Multi Gym | 34000 | Coscore |
| P5 | Massage Chair | 5500 | Regrosene |
| P6 | Belly Vibrator Belt | 6500 | Ambawya |
(i) To display the names of all the products with price more than 20000.
(ii) To display the names of all 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 the details :
"P7", "Vibro Exerciser", 28000, "Aone".
(i)
SELECT PNAME FROM FITNESS WHERE PRICE > 20000;+-----------+
| PNAME |
+-----------+
| Treadmill |
| Multi Gym |
+-----------+
(ii)
SELECT PNAME
FROM FITNESS
WHERE MANUFACTURER = "Aone";+-------+
| PNAME |
+-------+
| Bike |
+-------+
(iii)
UPDATE FITNESS
SET PRICE = PRICE * 0.75;(iv)
INSERT INTO FITNESS
VALUES("P7", "Vibro Exerciser", 28000, "Aone");