题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select
ct.pay_ability,
concat (
round(
sum(if (lt.overdue_days > 0, 1, 0)) / count(lt.agreement_id) * 100,
1
),
'%'
) as overdue_ratio
from
loan_tb as lt
left join customer_tb as ct on lt.customer_id = ct.customer_id
group by
ct.pay_ability
order by
overdue_ratio desc
没有赛事奖项么？另外，项目经历字有点多哈，建议突出一下重点：用的什么技术，解决什么问题，达到什么效果。