SQL Assignment02 - Select Statement

Now, As we created some tables with data, lets do some practice with basic SQLs, Try to write queries for below statements -

-- List all data from table DEPOSIT
-- List all data from table BORROW
-- List all data from table CUSTOMERS
-- List all data from table BRANCH


--  get acc no and amount of Depositors
-- get acc no and amount of Depositors
-- give names of Customers
-- give name of Branch
-- give name of Borrowers
-- gives name of customer living in NAGPUR
-- give name of depositor having amount greater than 4000
-- give account date of customer ANIL
-- give name of all branches located in Mumbai
-- give name of borrower having loan no 206
-- give name of depositor having account in VRCE
-- give name of all branches located in DELHI
-- give name of customers who opened account after date '1-12-96'
-- give acc no and deposit amt of customers having account opened b/w date 1-12-95 and 1-5-96
-- give name of city where branch Karolbagh is located
-- give all details of customer 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