Write command of SQL for
(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 Excersiser”, 28000, “Aone”
Ans:
(i) SELECT * FROM FITNESS WHERE PRICE > 20000;
(ii) SELECT * FROM FITNESS WHERE MANUFACTURER – “Aone”;
(iii) UPDATE FITNESS SET PRICE = PRICE – PRICE * 25/100;
(iv) INSERT FITNESS VALUES (“P7”, “Vibro Exerciser”, 28000, “Aone”);