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.