Tricky~22min

The Fixed Rate That Changed Mid-Term

6 fixed-rate loans show a different applied_rate between two billing statements — a fixed rate is never supposed to change mid-term. A rate-lock bug re-priced these borrowers. 24 more loans also show the rate changing between statements, but they're variable-rate loans, which are supposed to reprice.

Tables you'll query

loansbilling_statements

What you'll learn

JOINs
Investigate this case →