Question

Consider the following table :

                          Table: PharmaDB

RxID	DrugID	DrugName	Price	Pharmacy Name	Pharmacylocation
R1000	5476	Amlodipine	100.00	Rx Pharmacv	Pitampura, Delhi
R1001	2345	Paracetamol	15.00	Raj Medicos	Bahadurgarh, Haryana
R1002	1235	Nebistar	60.00	Mv Chemist	Rajouri Garden, Delhi
R1003	6512	Vita Plus	150.00	My Chemist	Curgaon, Haryana
R1004	5631	Levocitrezine	110.00	Rx Pharmacy	South Extension, Delhi

Write commands in SQL for (i) to (iv):

(i) To increase the price of "Amlodipine" by 50.

(ii) To display all those medicines whose price is in the range 100 to 150.

(iii) To display the Maximum price offered by pharmacy located in "Gurgaon"

(iv) To display the Drug ID, DrugName and Pharmacy Name of all the records in descending order of their price.

Answer 1

(i) Update PharmaDB set Price = price+50 Where DrugName = "Amlodipine";

(ii) Select * From PharmaDB where price between 100 and 150;

(iii) Select Max(Price) from pharmaDB where Pharmacylocation like  "% Gurgaon %" ;

(iv) Select Drug ID, DrugName, pharmacyName from PharmaDB order by price desc;