Skip to main content
All Problems
medium0% acceptance

Credit Card Utilization Rate

The risk team needs to assess credit card utilization. For each credit card (card_type = 'credit') that has a credit_limit > 0, compute the utilization rate as (account balance / credit_limit * 100). Return card_number, credit_limit, account balance, and utilization_pct rounded to 1 decimal. Sort by utilization_pct descending.

Schema

🔑idINT
🔗customer_idINT
account_typeTEXT
balanceREAL
currencyTEXT
opened_atTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute