What are the names of the different bank branches, and what are their total loan amounts Show bar chart, show by the x axis from high to low.
CREATE TABLE customer (
    cust_ID varchar(3),
    cust_name varchar(20),
    acc_type char(1),
    acc_bal int,
    no_of_loans int,
    credit_score int,
    branch_ID int,
    state varchar(20)
)

CREATE TABLE bank (
    branch_ID int,
    bname varchar(20),
    no_of_customers int,
    city varchar(10),
    state varchar(20)
)

CREATE TABLE loan (
    loan_ID varchar(3),
    loan_type varchar(15),
    cust_ID varchar(3),
    branch_ID varchar(3),
    amount int
)
SELECT bname, SUM(amount) FROM bank AS T1 JOIN loan AS T2 ON T1.branch_ID = T2.branch_ID GROUP BY T1.bname ORDER BY bname DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the names of the different bank branches, and what are their total loan amounts Show bar chart, show by the x axis from high to low. ### Input: CREATE TABLE customer (
    cust_ID varchar(3),
    cust_name varchar(20),
    acc_type char(1),
    acc_bal int,
    no_of_loans int,
    credit_score int,
    branch_ID int,
    state varchar(20)
)

CREATE TABLE bank (
    branch_ID int,
    bname varchar(20),
    no_of_customers int,
    city varchar(10),
    state varchar(20)
)

CREATE TABLE loan (
    loan_ID varchar(3),
    loan_type varchar(15),
    cust_ID varchar(3),
    branch_ID varchar(3),
    amount int
) ### Response: SELECT bname, SUM(amount) FROM bank AS T1 JOIN loan AS T2 ON T1.branch_ID = T2.branch_ID GROUP BY T1.bname ORDER BY bname DESC