SQL Assignment03 - Join or Cartesian Product

Some more queries on SQL to work on --

1. Give names of customers having living city BOMBAY and branch city Nagpur.
2. Give Names of Customers having the same living city as their branch city.
3. Give names of customers who are borrowers as well as depositors and having living city as Nagpur.
4. Give names of customers who are depositors and having the same branch city as that of Sunil.
5. Give names of depositors having the same living city as that if Anil and having deposit amount greater than 2000.

6. Give names of borrowers having deposit amount greater than 1000 and loan amount greater than 2000.
7. Give name of depositors having the same branch as the branch of Sunil.
8. Give name of borrowers having loan amount greater than the loan amount of Pramod.
9. Give name of Customers living in the city where branch of depositors Sunil is located.
10. Give LOANNO and LOAN AMOUNT of borrowers having the same branch as that of Sunil.
11. Give LOANNO, LOAN AMOUNT, ACCOUNT NO and DEPOSIT AMOUNT of customers living in city Nagpur.
12. Give LOANNO, LOAN AMOUNT, ACCOUNT NO and DEPOSIT AMOUNT of customers having branch located in Bombay.
13. Give LOANNO, LOAN AMOUNT, ACCOUNT NO, DEPOSIT AMOUNT, BRANCH NAME, BRANCH CITY and LIVING CITY of Pramod.
14. Give deposit details and load details of customers in the city  where Pramod is living.
15. Give names of depositors having the same branch city as that of Sunil and having the same living city as that of Anil.
16. Gave name of depositors having amount greater than 5000 and having the same living city as Pramod.
17. Give city of customers having the same branch city of Pramod.
18. Give branch city and living city of Pramod.
19. Give branch city of Sunil and Branch city of Anil.
20. Give the living city of Ashok and living city of Ajay.




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