1.Show borrower id, borrower state, borrowing amount for loan requests with the largest loan requested amount.(25 points). Please use two approaches to answer this question.

a.One approach will use TOP (11 points).

b.Another approach uses subquery (14 points).

2.Show borrower id, borrower state, borrower registration date, requested amount for all borrowers including borrowers who haven't requested any loans no any loans (10 points).

3.Show loan request (all information) for all loans that have paid more than 15 installments, rank them by the total number of installments so far in descending. (18 points)

Loanrequests Loanpayments Members Listing Number 8 Installment_num BorrowerID BorrowerID ListingNumber State AmountRequested Principal_Balance CreditGrade Principal_Paid Title interestPaid 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 The following table provides Table structure: Tables Columns Data Type Explanations BorrowerID Varchar(50) Borrower ID, primary key Members state Varchar(50) Member state ListingNumber Number Loan requested, primary key BorrowerID Varchar(50) Borrower ID, foreign key links to Member table LoanRequests AmountRequested Number Requested Loan Amount CreditGrade Varchar(50) Borrower credit grade Title Varchar(350) The title of loan requests The installment number, part of primary Installment_num Number key Loan request ID, part of primary key, ListingNumber Number Foreign key relates to Loan Request table. Loan principal balance (i.e., how much loan Loanpayments Principal balance Number is left) after current installment payment Loan principal amount was paid in current Principal Paid Number installment payment InterestPaid NUMBER Loan interests were paid in current installment payment Note: 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