Page 13 - IP

(i) To display FCODE, NAME and PRICE of items that have Price less
than < 5,000. 1

(ii) To display NAMES and PRICE of those Furniture Items that have
‘table’ anywhere in their names. 1

(iii) To display WCode of Furniture Items. There should be no duplicate
values. 1
(iv) To display the NAMES and PRICE increased by 500.00 of all the
furniture items. (Price should only be displayed as increased; there
should be no increase in the data in the table) 1

(v) To display FCODE and NAME of each Furniture Item in descending
order of FCODE. 1

(vi) To display the details of all the Furniture Items which have
Manufacturing date (MANUFDATE) between 01-JAN-2016 and
15-JUN-2017 (inclusive of both the dates). 1

(vii) To display the average PRICE of all the Furniture Items, which are
made of Wood with WCODE as W02. 1

(viii) To display WCODE wise, WCODE and the highest price of
Furniture Items. 1

(ix) SELECT SUM(PRICE) FROM Furniture WHERE WCODE=’W03’; 1

(x) SELECT COUNT(DISTINCT PRICE) FROM Furniture; 1

6. (a) Write SQL query to create a table ‘Inventory’ with the following
structure : 2

Field Type Constraint

MaterialId Integer Primary key

Material Varchar (50) NOT NULL

Category Char

DatePurchase Date

90 9 P.T.O.