Saved Bookmarks
| 1. |
Consider the following table and wrtite SQL statements Table MenuIDItemDescriptionPriceP001Sambar VadaSouth Indian40P002Dal MaakhaniNorth Indian150P003NoodlesChineese100P004Idli SabarSouth Indian50P006Sarson SaagNorth Indian170P007DosaSouth Indian120P008PizzaItalian200i. To add a new row with the following data “P009”, “Lemon Rice”, “South Indian”, 140 ii. Display details of all Menu items in the descending order of Price iii. Display Item and Description of those Items whose price is between 100 and 150 iv. Add a new column Rating datatype as int to the table Menu |
|
Answer» (i) Insert into Menu values (“P009”, “Lemon Rice”, “South Indian”, 140); (ii) Select * from Menu order by Price; (iii) Select Item, Description from Menu Where price between 100 and 150; (iv) Cardinailty - 7 Degree – 4 (v) Alter Table Menu Add Rating int; |
|