Consider the following relations database schema. The primary key is underlined, and all attributes are of type string if not indicated otherwise. branch(branch_name, branch_city)...

Consider the following relations database schema. The primary key is underlined, and all attributes are of type string if not indicated otherwise.

branch(branch_name, branch_city)

customer(customer_id, customer_name,customer_street,customer_city)

account(account_number, branch_name, balance: integer)

depositor(customer_id, account_number)

Write SQL queries to:

1. Find all the branch names with customers who have accounts of balance less than $2000 and the branch is located in LA.


2. Delete all customers who do not have an account. (Assume the bank keeps the customer information even if the account is closed.