How to solve current queries in SQL Server?

Question

I have many queries in SQL server which I have problem to solve them please help me to solve them, and I try to write most of the queries by nested queries if it is possible.
1: displaying The customer name and the bank_branch number that customer has received loan  from that branch.
2:displaying pair name of customers that received equal amount loan.   3:displaying customer names that have received more than 2 loan .   4: displaying the customer names that their loan's amount is/are more than their account's balance.
5: displaying the number and address of bank_branches which has/have given loan for all of their customers.   6: displaying name and address of banks which all of their branches have given more than 10 loan's for their customers.
7:displaying pair name customers whose phone number start with '383'.       this is my E/R SCHEMA.

Dipankar Biswas · Answer

ok fnd I'll try..as soon as possible..

Dipankar Biswas · Answer

Hi.. fnd at first u need to know Table relation and table joining. Query is same..   1. Table relation  https://www.youtube.com/watch?v=jyklg0cTN3M
And 2.Table Join         http://www.c-sharpcorner.com/Blogs/46248/how-to-join-table-in-sql-server.aspx           Example: Table_1 and Table_2 (must be need any one type relation(pk,fk etc) between two tables                       Table1_id = Table2_id

Dipankar Biswas · Answer

sorry friend, actually  was  not time at last night. can you send me your tables backup ?
I'll try..

Dipankar Biswas · Answer

Hi..
my simple try for u.. by using single table.

Pankaj Kumar Choudhary · Answer

Hello @Wilson we can try to solve your problem .  can you post this image again because this not completely visible ...............
Please Post this image ....
Really i want to solve these problem.............

Dipankar Biswas · Answer

hi..
Check this link.. to help.. https://msdn.microsoft.com/en-us/library/ms187731.aspx
http://www.codeproject.com/Articles/300785/Calculating-simple-running-totals-in-SQL-Server
https://msdn.microsoft.com/en-us/library/ms179859.aspx
https://msdn.microsoft.com/en-IN/library/ms181567.aspx

Joe Wilson · Answer

This is my bank diagram so please help me to solve the queries according to this diagram and by the way , I want to write queries by nested queries, if possible.

Joe Wilson · Answer

This is my bank diagram so please help me to solve the queries according to this diagram and by the way , I want to write queries by nested queries, if possible.

Joe Wilson · Answer

Well, These are all tables of the E/R SCHEMA , and as I mentioned before, I have problem in joining the tables or use nested queries to solve the queries above , so please guide me to solve them.Thank you

Joe Wilson · Answer

Thank you for your answer, but I don't have just one table which have all field I have 7 table for entities and for A-C AND L-C and the problem is answering to queries according to these 7 tables and I have problem in joining and use nested queries by using tables , so please guide me related to my explanation.