Question Give the Your Answers !

1. Add a column called ‘telephone’ of data type number and size = 10 to the client_master   table.
2. Change the size of sell_price column in product_master to 10,2.
3. Change the name of the salesman_maste to sman_mast.
4. Find the names of all clients having ‘i’ as the second letter in their name.
5. Find out the clients who stay in a city whose second letter is ‘a’.
6. Find the list of all clients who stay in ‘Delhi’ or ‘Bombay’.
7. Print the list of clients whose bal_due is greater than 12000.
8. Display the order information for client_no ‘C00001’ and ‘C00002’.
9. Find the product whose selling price is greater than 2000 and less than or equal to 5000.
10. List the name, city and state of clients who are not in the state of ‘Maharashtra’.
11. List all the products whose qty_on_hand is more than 10.
12. Display Name and yesterday’s sales of salesman whose remark is average.
13. Display “In Progress” orders.
14. Display details of all the orders whose product rate is more than 1000 and qty_ordered is between 20 and 50.
15. Display all the products whose name starts with ‘M’.
16. Display all the products whose profit percent is more than 3 and sell price is between 800 and 15000.
17. Display all the sales order whose delytype is ‘F’ and Billyn is ‘Y’.
18. Delete all salesman from the salesman_master whose salaries are equal to Rs. 3500.
19. Delete all products from product_master where the quantity on hand is equal to 100.
20. Delete from client_master where the column state holds the value ‘Tamil Nadu’