Question

Mr. Ramdin runs his medical store and he created table STORE with Ayurvedic Medicines. Write SQL

commands for (i) to (iv) and output for (v) to (vii)​

Answer 1

Answer:

(i) select *from store

where type="syrup";

(ii) select *from store

where company="Dindayal";

(iii) select *from store

order by price desc;

(iv)insert into store

values(E4992,"kaya kalp","Patanjali","churna",2002-1-12,2006-31-1,60);

(v) Products of patanjali and badyanath displayed

(vi) 5

(vii) 60

Explanation: