From a loans table with borrower_id, loan_date, principal, and interest_rate, write a query that returns borrowers who refinanced (took a new loan within 60 days of a previous one) at a lower rate.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

From a loans table with borrower_id, loan_date, principal, and interest_rate, write a query that returns borrowers who refinanced (took a new loan within 60 days of a previous one) at a lower rate.

Practice more