Prosper Data SQL Statements | P2P Lending, Peer to Peer Lending, People to People Lending

This is a page of all sql statements I have found useful when looking into data. Don’t see one you would like, just ask.

If you found this helpful and you would like to donate to show your appreciation please feel free to do so. Thanks, RateLadder.com

Count of Loans Not Current:

SELECT Count(*) FROM loan WHERE status != ’Paid’ AND status != ’Current’ AND status != ’Payoff in progress’

Count of Loan Statuses:

SELECT status, count(status) FROM loan GROUP BY status

Count of Listings in a Period:

SELECT Count(DISTINCT [key]) FROM listing WHERE creationdate>=’1/1/2006′ AND creationdate<'2/1/2006'

Count of Unique Bidders in a Period:

SELECT Count(DISTINCT memberkey) FROM bid WHERE creationdate>=’1/1/2006′ AND creationdate<'2/1/2006'

Count of Loans Originated in a Period:

SELECT Count(DISTINCT [key]) FROM loan WHERE creationdate>=’1/1/2006′ AND creationdate<'2/1/2006'

Count of Loans Originated:

SELECT Count(DISTINCT [key]) FROM loan

Total Lent in a Period:

SELECT Sum(amountborrowed) FROM loan WHERE creationdate>=’1/1/2006′ AND creationdate<'2/1/2006'

If you found this helpful and you would like to donate to show your appreciation please feel free to do so. Thanks, RateLadder.com

Leave a Reply

Your email address will not be published. Required fields are marked *