In a database there are two tables :
Table : ITEM
ICode |
Name |
Price |
101 |
Television |
75000 |
201 |
Computer |
42000 |
303 |
Refrigerator |
90000 |
404 |
Washing Machine |
27000 |
Table : BRAND
ICode |
Brand |
101 |
Sony |
202 |
HP |
303 |
LG |
404 |
IFB |
Write MySQL queries for the following:
(i) To display ICode, IName and corresponding Brand of those items whose price is between 20000 and 45000 (both values inclusive).
(ii) To display Icode, price and Brand of Televisions.
(iii) To increase the price of all items by 15%.