Problem
In SQL. Given the following relational database schema . The primary key is underlined. All attributes are of type string if not indicated otherwise.
o branch(branch_name,branch_city,assets: integer)
o customer(customer_i,customer_name,customer_street,customer_city)
o account(account_number,branch_name,balance)
o depositor(customer_id,account_number)
1) Find the names of customers who have an account in the branch with highest assets.
2) Find the names of customers who live in the same city where the branches are located that the customers use.
3) Find the names of customers whose account balance is less than $1,000 and the branch that has the account is located in Miami.
4) Find the names of customers that have accounts in every branch in Miami.
5) Find the names of customers who do not have an account. (assume the bank keeps the customer information even if the account is closed.)
The response must include a reference list. Using Times New Roman 12 pnt font, double-space, one-inch margins, and APA style of writing and citations.