Using the following schemas, give the expressions in SQL.

Posted by Naidulaxmi under NoSql on 12/26/2013 | Points: 10 | Views : 829 | Status : [Member] | Replies : 0
hi friends,

Using the following schemas, give the expressions in SQL.
Branch schema (branch name, branch city, assets)
Customer schema (customer name, customer street, customer cit
Loan schema (branch name, loan number, amount)
Borrower schema (customer name, Loan number)
Account schema (branch name, account number, balance)
Depositor schema (Customer name, account number)
a) Find the names of all customers whose street address include
b) Find average balance for each customer who livesin Harrison
accounts?
c) Find all customer who have a loan at bank whose names
’jones’?
d) Dispaly customernames in alphabetical order who have a
branch?
e) Find all customers having loan, account or bothat a bank?
f) Find all customers who have account but not loan at bank?


Could you please give me all questions answers.

Thnks,
naidu

appalanaidu


Responses

(No response found.)

Login to post response