Skip to main content
All Problems
easy0% acceptance

Minimum and Maximum Loan Interest Rates

The product pricing analyst needs a quick snapshot of the interest rate range. Write a single query that returns the minimum interest_rate, maximum interest_rate, and the difference between them (as rate_spread).

Schema

🔑idINT
🔗customer_idINT
loan_typeTEXT
principalREAL
interest_rateREAL
term_monthsINT
start_dateTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute