Notes

Assignment 25:

INSERT INTO customer VALUES (2001,'Regular','Mark','N',Null,'[email protected]',9000000000,Null,Null,Null);


Assignment 26:

INSERT INTO customer VALUES (2002,'Regular','Travin','M',Null,Null,8000000000,Null,Null,Null);


Assignment 27:

INSERT INTO customer VALUES (2003,'Regular','Dave',Null,Null,'[email protected]',7000000000,Null,Null,Null);


Assignment 28:

INSERT INTO item VALUES ('I1001','Cosmetic','SunScreen',50,0,-5,'A');
Modified : INSERT INTO item VALUES ('I1001','Cosmetic','SunScreen',50,0,5,'A');

Assignment 29:

INSERT INTO item VALUES (I1002,'Biscuit','ParleD',20,0,10,'D');
Modified : INSERT INTO item VALUES (I1002,'Biscuit','ParleD',20,0,10,'B');


Assignment 30:

INSERT INTO retailoutlet VALUES ('R1001','NewYork',Null);

Assignment 31:

INSERT INTO retailoutlet VALUES ('R1002','Null',Null);
MODIFIED : INSERT INTO retailoutlet VALUES ('R1001','USA',Null);

Assignment 32-33:Table does Not EXIST :P


Assignment 34:
INSERT INTO Supplier VALUES ('S1001','Ark Suppliers',9999999999,'[email protected]','Mumbai');

Assignment 35:
INSERT INTO Supplier VALUES ('S1001','Crane Suppliers',8888888888,'[email protected]','Delhi');
Modified : INSERT INTO Supplier VALUES ('S1002','Crane Suppliers',8888888888,'[email protected]','Delhi');

Assignment 36:
INSERT INTO Supplier VALUES ('','Fur Suppliers',8999999999,'[email protected]','Chandigarh');
Modified : INSERT INTO Supplier VALUES ('S1003','Fur Suppliers',8999999999,'[email protected]','Chandigarh');


Assignment 37:
To do this we need to change the size of supplier_city CHAR(20)
INSERT INTO Supplier VALUES ('S1099','Neo Supply',7878787878,'[email protected]','Greater Hyderabad');



----------ECLIPSE ASSIGNMENTS-------------

Assignment 39:SELECT DESCR, PRICE from item where descr like '%Hard disk%';

Assignment 40:SELECT * FROM quotation where qstatus in ('Rejected','Closed');

Assignment 41:select designation,salary from empdetails where DESIGNATION in ('Billing Staff','Manager');

Assignment 42:select roid,location from retailoutlet where MANAGERID is null;

Assignment 43:SELECT orderid,quotationid,status FROM orders where orderdate between '1-Dec-2010' and '1-Jan-2011';

Assignment 44:select itemcode,descr,price from item where DESCR like '%Shirt%' OR DESCR like '%Skirt%' and CATEGORY = 'B';

Assignment 45:select DISTINCT designation,salary from empdetails;

Assignment 46:select itemcode,descr,price from item;

Assignment 47:select quotationid,supplierid from quotation where qstatus in ('Accepted','Rejected');

Assignment 48:select supplierid,sname from supplier where sname like '_i%';

Assignment 49:select DISTINCT itemtype from item;

Assignment 50:SELECT orderid,quotationid,status,pymtdate FROM orders WHERE STATUS in ('Partial Delivery','Ordered');

Assignment 51:select distinct itemtype,category from item;

Assignment 52:select empid,salary,salary+salary*0.1 as incr_salary,salary*0.1 as incr_amount from empdetails;