Cold Case~60min

The Loan Portfolio That Was Riskier Than Reported

7 loans show a payment posted 1 day before every single month-end snapshot, then reversed 1 day after — every month, for 6 months straight. Excluding those round-trip payments, these loans are delinquent every single month. 5 more loans also have a reversal on file, but it's a single one-off NSF bounce mid-month, unrelated to the reporting date and not repeating.

Tables you'll query

loanspayments

What you'll learn

JOINsDate & Time FunctionsAggregations & GROUP BY
Investigate this case →