First page Back Continue Last page Graphics
Reading Queries
{customer-name}(balance>amount(account depositor borrower loan))
{branch-name}(branch) {branch-name}(branch-city customer-city(branch account depositor customer))
{X.customer-name} (X.account-number = Y.account-number X.customer-name Y.customer-name (X(depositor) Y(depositor)))
Notes:
First: Give the name of the customers who have an account with a higher balance than the amount of one of the loans of these customers at the same branch.
Second: Give the name of the branches that only have depositors from their own city.
Third: Give the name of customers who have a joint account with someone else.