questions

[SjxSubham]

Assignment 3

insert data into customer table

INSERT INTO CUSTOMER (Cust_no, Cust_name, State) VALUES (1001, 'Prakash', 'UP');
INSERT INTO CUSTOMER (Cust_no, Cust_name, State) VALUES (1002, 'Mukesh', 'AP');
INSERT INTO CUSTOMER (Cust_no, Cust_name, State) VALUES (1003, 'Murti', 'UP'); -- Fixed special character issue
INSERT INTO CUSTOMER (Cust_no, Cust_name, State) VALUES (1004, 'Rajan', 'WB');
COMMIT;

2. SELECT * FROM ITEM;
3. SELECT * FROM CUSTOMER WHERE State = 'UP';
4. SELECT * FROM CUSTOMER WHERE Cust_name = 'Prakash';
5. SELECT * FROM CUSTOMER WHERE State IN ('AP', 'WB');
6. SELECT * FROM CUSTOMER WHERE State <> 'UP';
7. SELECT * FROM ITEM WHERE I_name = 'Nail';
8. SELECT * FROM ITEM WHERE I_price BETWEEN 2 AND 6;
9. SELECT * FROM ITEM WHERE I_price NOT BETWEEN 2 AND 6;
10. SELECT * FROM ITEM WHERE I_price > 1.00 AND I_qty < 200;
11. SELECT * FROM ITEM WHERE I_name LIKE '%o%';
12. SELECT * FROM ITEM WHERE I_name LIKE 'A%';
13. SELECT * FROM ITEM WHERE I_name LIKE '%r';
14. SELECT * FROM CUSTOMER ORDER BY State DESC;

Assignment 3

Insert the following data into the ITEM table
I_no I_name I_price I_qty
1 Sword 2.25 50
2 Nut 5.00 110
3 Bolt 3.99 75
4 Hammer 9.99 125
5 Washer 1.99 100
6 Nail 0.99 300
7 Axe 3.55 25
8 Scissor 2.19 15