题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select
pay_ability,
concat(
round(count(if(overdue_days is not null, 1, null)) * 100 / count(*),1),
"%"
) as overdue_ratio
from
loan_tb lt inner join customer_tb ct on lt.customer_id = ct.customer_id
group by pay_ability
order by overdue_ratio desc
