Write mysql

1. Find all customers who have a loan at the bank but do not have an account at the

   bank

2. Find the names of all branches that have greater assets than all branches located in

   Horseneck. (using both non-nested and nested select statement)

depoitor: customer_name 1 Hayes 2 Johnson 3 Johnson 4 Jones 5 Lindsay 6 Smith 7 Turner account number A-102 A-102 A-201 A-217 A-222 A-215 A-305 employee: branch name Perryridge Perryridge Perryridge Downtown Downtown Downtown Austin Austin E employee_name salary 1 Adams 2 Brown 3 Gopal 4 Johnson 5 Loreena 6 Peterson 7 Rao 8 Sato 1500 1300 5300 1500 1300 2500 1500 1600 el loan branch_name Round Hill Downtown Perryridge Perryridge Downtown Redwood Mianus loan_number amount 1 L-11 2 L-14 3 L-15 4 L-16 5 L-17 6 L-23 7 1-93 900 1500 1500 1300 1000 2000 500 account: Filter criteria branch name balance borrower: @localhost [console 1]bank.borrower [@localhost] X Tx: Auto customer-name : loan-number 8 Williams branch city Brooklyn branchname assets - Horseneck own 5 Perryridge Horseneck Bennington Palo Alto Horseneck 8 Round Hill customer-name # 1 customer-street customer_city Sand Hill ts 0 0 0 0 0 0 0 0 5497773 1047731 S79 2 1 SA si nnc yye -In akke kk00k cttc egle nnAn 5 9 47137 11121 rtst snos rer oyo 1BBHRH BMB ^_^ 0 ssshh htuh 0 c1215725 a000-120 1122223 arycnii! 12345678 da 1234567 12345678 1 123456789 10 11 12