Question

Consider the table ITEMS.

1. SELECT ITEMCODE, NAME FROM ITEMS WHERE CATEGORY = ‘Stationery’; 

2. SELECT * FROM ITEMS WHERE SALES_ PRICE < UNIT_PRICE; 

3. SELECT CATEGORY, COUNT(*) FROM ITEMS GROUP BY CATEGORY;’

Answer 1

1. 

ltem_Code	Name
0001	Pencil
0002	Pen
0003	Notebook
0007	Pen

2. 

ltem_Code	Name	Category	Unit_Price	Sales_Price
0007	Pen	Stationery	10.00	9.00

3. 

Category	Count(*)
Stationery	4
Footwear	1
Fruits	2