database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-numb
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-numb
at least one account at that branch.
Find the names and account number of customers who have the
3 highest balances in their accounts.
If the bank gives out 5% interest to all accounts, show the
branch name and total interest across each branch.
database Branch(branch-name, branch-city, assets) Customer(customer-name, customer-street, customer-city) Loan(loan-number, branch-name, amount) Borrow(customer-name, loan-number) Account(account-number, branch-name, balance) Depositor(customer-name, account-number)