Consider the following tables STORE and SUPPLIERS. Write SQL commands for the statements (i) to (iii) and give the output for SQL query (iv).

Table: STORE

ItemNo	Item	Scode	Qty	Rate	LastBuy
2005	Sharpener Classic	23	60	8	2009-06-31
2003	Ball Pen 0.25	22	50	25	2010-02-01
2002	Gel Pen Premium	21	150	12	2010-02-24
2006	Gel Pen Classic	21	250	20	2009-03-11
2001	Eraser Small	22	220	6	2009-01-19
2004	Eraser Big	22	110	8	2009-12-02
2009	Ball Pen 0.5	21	180	18	2009-11-03

Table: SUPPLIERS

Scode	Sname
21	Premium Stationery
23	Soft Plastics
22	Tetra Supply

(i) To display details of all the items in the Store table.

(ii) To display ItemNo and item name of those items from store table whose rate is more than 15.

(iii) To display the details of those items whose supplier code is 22 or Quantity in store is more than 110 from the table Store.

(iv) SELECT Rate*Qty FROM STORE WHERE Itemno = 2004;

(i)

SELECT * FROM STORE;

Output

+--------+-------------------+-------+-----+------+------------+
| ItemNo | Item              | Scode | Qty | Rate | LastBuy    |
+--------+-------------------+-------+-----+------+------------+
|   2001 | Eraser Small      |    22 | 220 |    6 | 2009-01-19 |
|   2002 | Gel Pen Premium   |    21 | 150 |   12 | 2010-02-24 |
|   2003 | Ball Pen 0.25     |    22 |  50 |   25 | 2010-02-01 |
|   2004 | Eraser Big        |    22 | 110 |    8 | 2009-12-02 |
|   2005 | Sharpener Classic |    23 |  60 |    8 | 2009-06-30 |
|   2006 | Gel Pen Classic   |    21 | 250 |   20 | 2009-03-11 |
|   2009 | Ball Pen 0.5      |    21 | 180 |   18 | 2009-11-03 |
+--------+-------------------+-------+-----+------+------------+

(ii)

SELECT ItemNo, Item FROM STORE WHERE Rate > 15;

Output

+--------+-----------------+
| ItemNo | Item            |
+--------+-----------------+
|   2003 | Ball Pen 0.25   |
|   2006 | Gel Pen Classic |
|   2009 | Ball Pen 0.5    |
+--------+-----------------+

(iii)

SELECT * FROM STORE WHERE Scode = 22 OR Qty > 110;

Output

+--------+-----------------+-------+-----+------+------------+
| ItemNo | Item            | Scode | Qty | Rate | LastBuy    |
+--------+-----------------+-------+-----+------+------------+
|   2001 | Eraser Small    |    22 | 220 |    6 | 2009-01-19 |
|   2002 | Gel Pen Premium |    21 | 150 |   12 | 2010-02-24 |
|   2003 | Ball Pen 0.25   |    22 |  50 |   25 | 2010-02-01 |
|   2004 | Eraser Big      |    22 | 110 |    8 | 2009-12-02 |
|   2006 | Gel Pen Classic |    21 | 250 |   20 | 2009-03-11 |
|   2009 | Ball Pen 0.5    |    21 | 180 |   18 | 2009-11-03 |
+--------+-----------------+-------+-----+------+------------+

(iv) SELECT Rate*Qty FROM STORE WHERE Itemno = 2004;

Output

+------------+
| Rate * Qty |
+------------+
|        880 |
+------------+