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