1. In SQL. Given the following relational database schema . The primary key is underlined. All attributes are of type string if not indicated otherwise.  branch(branch_name,

 

1.

In SQL. Given the following relational database schema . The primary key is underlined. All attributes are of type string if not indicated otherwise.

 branch(branch_name,branch_city,assets: integer)

 customer(customer_i,customer_name,customer_street,customer_city)

 account(account_number,branch_name,balance)

 depositor(customer_id,account_number)

a. Find the names of customers who have an account in the branch with highest assets.

b. Find the names of customers who live in the same city where the branches are located that the customers use.

c. Find the names of customers whose account balance is less than $1,000 and the branch that has the account is located in Miami.

d. Find the names of customers that have accounts in every branch in Miami.

e. Find the names of customers who do not have an account. (assume the bank keeps the customer information even if the account is closed.)