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