第3章 SQL 习题 - 3.8

3.8考虑下图中的银行数据库，其中加下划线的是主码。为这个关系数据库构造出如下SQL查询：

branch(branch_name, branch_city, assets)
customer(customer_name, customer_street, customer_city)
loan(loan_number, branch_name, amount)
borrower(customer_name, loan_number)
account(account_number, branch_name, balance)
depositor(customer_name, account_number)

为了解题方便，先创建这些关系，并填充一些样例数据。

drop table if exists branch cascade;
drop table if exists customer cascade;
drop table if exists loan cascade;
drop table if exists borrower cascade;
drop table if exists account cascade;
drop table if exists depositor cascade;
create table branch(
    branch_name varchar not null, -- '支行名称', 
    branch_city varchar , -- '所在城市', 
    assets numeric(18,2) DEFAULT '0.00' , -- '账户余额',
    PRIMARY KEY(branch_name)
);
create table customer(
    customer_name varchar not null , -- '客户名称', 
    customer_street varchar , -- '居住街道', 
    customer_city varchar , -- '居住城市',
    primary key(customer_name)
);
create table loan(
    loan_number varchar , -- '贷款号', 
    branch_name varchar , -- '支行名称', 
    amount numeric(18, 2) , -- '贷款金额',