Urgently need!

Please solve these within 20mins. TIA

1. Write down the following SQL queries and also write down their outputs a) Find out the loan amount of the customers whose customer street is Main. [4] b) Find out the name of the city of the customers whose Bank branch has the second maximum amount of assets. [6] c) Find the average account balance of those branches where the average account balance is greater than $1000 and the branch balance is 900000 or 1700000.(You dont need to find output table for this one) [5]

d) Find out the name and account number of the customers whose Branch city is in Horseneck and the account balance of the customers are more than 400. [6] e) Write down the account number of the customer whose name starts with J or H and whose bank branch name is Downtown. [5]

Account ACCOUN T_NUMB ER BALANCE A-101 A-215 BRANCH NAME Downtown Mianus Perryridge Round Hill Perryridge Redwood Brighton 500 700 400 Borrower CUSTOMER_NA ME Jones Smith Hayes Jackson Curry Smith Williams Adams LOAN_NUMBE R L-17 L-23 L-15 L-14 A-102 A-305 350 L-93 A-201 900 L-11 A-222 700 A-217 750 L-17 L-16 Loan LOAN NU MBER L-17 L-23 BRANCH NA ME Downtown Redwood Perryridge Downtown Mianus Round Hill Perryridge AMOUN T 1000 2000 1500 1500 Branch BRANCH N AME Downtown Redwood Perryridge Mianus Round Hill Pownal L-15 BRANCH CITY Brooklyn Palo Alto Horseneck Horseneck Horseneck Bennington Rye Brooklyn ASSETS 900000 2100000 1700000 400200 8000000 400000 3700000 L-14 L-93 500 L-11 900 L-16 1300 North Town Brighton 7000000