Allocate the department situated in BOSTON to employee with employee number 7500 (tables EMPL, Dept)

Given the following tables :

Orders (OrdNo, Ord_date, ProdNo#, Qty) 
Product (ProdNo, Descp, Price)
Payment (OrdNo, Pment)

Write a query to delete all those records from table Orders whose complete payment has been made.

Write Query statements for following transaction : (Consider tables of question 12)

1. Increase price of all products by 10%.
2. List the details of all orders whose payment is pending as per increased price.
3. Decrease prices by 10% for all those products for which orders were placed 10 months before.

Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it.