Members BorrowerlD State Members The following table provides Table structure: Tables Columns LoanRequests Note: Loanpayments Prosper is a peer-to-peer lending platform. It allows borrowers to borrow loans from a pool of potential online lenders. Borrowers (i.e., Members) posted their loan Requests with a title and description. Borrowers specify how much they will borrow and the interest rate they will pay. If loan requests are fully funded (i.e., reached the requested amount) and become loans, borrowers will pay for the loans regularly (LoanPayment entity). The complete RDM is provided above. An Access Database with data is also available for downloading from Blackboard. BorrowerID state ListingNumber BorrowerID AmountRequested CreditGrade Title Installment num ListingNumber Loanrequests ListingNumber BorrowerlD AmountRequested CreditGrade Principal balance Title Principal Paid Interest Paid Data Type Varchar(50) Varchar(50) Number Varchar(50) Number Varchar(50) Varchar(350) Number Number Number 1 Number 00 NUMBER Loanpayments Installment num ListingNumber Principal Balance Principal Paid interest Paid Explanations Borrower ID, primary key Member state Loan requested, primary key Borrower ID, foreign key links to Member table Requested Loan Amount Borrower credit grade The title of loan requests The installment number, part of primary key Loan request ID, part of primary key, Foreign key relates to Loan Request table. Loan principal balance (i.e., how much loan is left) after current installment payment Loan principal amount was paid in current installment payment Loan interests were paid in current installment payment Please provide proper columns names in all queries. It is not required to be able run. But you can use the data to test your queries. Please post your query code under each question. 1. a. Write the code to create loanpayments Table (10 points) I b. Please insert the following record into this table (5 points) AmountReques Listing Num ber 123123 BorrowerlD wwwwwwww "26A634056994248467D 42E8" ted 1900 CreditGra de www "AA"10 Title a. One approach will use TOP (9 points). b. Another approach uses subquery (11 points). "Paying off my credit cards" c. Borrowers who have CreditGrade of AA want to double their requested amount. Please modify the LoanRequests table to reflect this additional information (5 points) 2. Show loan requests that are created by borrowers from CA and that are created for Debts, Home Improvement, or credit card (hint: the purpose of loans are in the column of title in Loanrequests table) (10 points) 3. Write the code to show UNIQUE loan request information for borrowers from California, Florida, or Georgia. (8 points) 4. Show borrower id, borrower state, borrowing amount for loan requests with the largest loan requested amount.(20 points). Please use two approaches to answer this question. 5. Show borrower id, borrower state, borrower registration date, requested amount for all borrowers including borrowers who haven't requested any loans (10 points). 6. Show listing number for all loans that have paid more than 15 installments, rank them by the total number of installments so far in descending (please use having). (15 points) 7. Each borrower has credit grade when he/she requests loans. Within each credit grade, please show loan request information (listing number, requested amount) for loan requests that have the lowest loan requested amount at that credit grade (17 points). Please use inline query