1. List all branch names and their assests AnswerAnswer: select branch_name, assets from branch; 2. List all accounts of Brooklyn branch AnswerAnswer: select account_number from account natural join branch where branch_city=’Brooklyn’; 3. List all loans with amount > 1000. AnswerAnswer: select * from loan where amount>1000; 4. List all accounts of Perryridge branch with balance…