Thursday, May 14, 2015
SQL Assignment07 - Update Statement
1. Give 10% interest to all depositors.
2. give 10% interest to all depositors having branch VRCE
3. Give 10% interest to all depositors living in city Nagpur.
4. Give 10% interest to all depositors having branch in city BOMBAY and living in Nagpur.
5. Add 100 Rs to deposit of Anil and assign it to Sunil.
6. Change the deposit of VRCE branch to 1000 and change the branch as VRCE_UPT
7. Assign to the deposit of Anil the maximum deposit from VRCE branch
8. Change the living city of VRCE branch borrowers to Nagpur.
9. Update deposit of Anil, give him max deposit from depositors in living city Nagpur.
10. Deposit the sum of the deposits of Sunil and Vijay in the account of Anil.
11. Transfer Rs 150 from Anil's account to Sunil.
12. Transfer Rs 150 from Anil's account to Sunil onlyif both are having same branch.
13. Transfer Rs 150 from Anil's account to Sunil onlyif both are living in Nagpur.
14. Add Rs 100 to account of all those depositors who are having the highest deposit amount in their respective branches
15. Add Rs 150 to the amount of all depositors having deposit higher than the average deposit
16. Add Rs 180 to the amount of all depositors having deposit higher than the average deposit of their branch.
17. Add Rs 130 to the amount of all the customers living in the city where their branch is located.
18. Add Rs 170 to the amount of all depositors having deposits equal to or higher than the average deposit of their branch.
Like the Facebook Page & join Group
For WHATSAPP group , drop a msg to 91-88-00-906098