Joe Wilson

Joe Wilson

  • NA
  • 7.8k
  • 434.6k

How to solve current queries in SQL Server?

May 16 2015 3:19 AM
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. 
 
 
 
 

Answers (11)