SQL Assignment04 - Operations

1. List all the customers who are depositors but not borrowers.
2. List all the customers who are both depositors and borrowers.
3. List all the customers, their amount, who are either depositors or borrowers and living in city Nagpur.
4. List all the depositors having deposit in all the branches where Sunil is having account.
5. List all the customers living in city Nagpur and having branch city BOMBAY or DELHI.

6. List all the depositors living in city Nagpur.
7. List all the depositors living in city Nagpur and having branch in city BOMBAY.
8. List the branch city of Anil and Sunil.
9. List the customers having deposit greater than 1000 and loan less than 10000.
10. List the borrowers having branch city same as that of Sunil.
11. List the cities of depositors having branch VRCE.
12. List the depositors having the same living city as that of Sunil and the same branch city as that of Anil.
13. List the depositors having amount less than 1000 and living in the same city as Anil.
14. List all the customers who are both depositors and borrowers and living in the same city as Anil.
15. List all the cities where branches of Anil and Sunil are located.
16. List all the customers names and the AMOUNT for depositors living in the city where either Anil or Sunil is living.
17. List the AMOUNT for the depositors living in the city where Anil is living.
18. List the cities which are either branch city of Anil or LIVING city of Sunil.
19. List the customers who are borrowers or depositors and having living city Nagpur and branch city same as that of Sunil.
20. List the customers who are both borrowers and depositors and having the same branch city as that of Anil.



Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098