题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select
c.pay_ability,
concat(
round(count(overdue_days) / count(*) * 100, 1),
'%'
) as overdue_ratio
from
loan_tb l
join customer_tb c on l.customer_id = c.customer_id
group by
pay_ability
order by
overdue_ratio desc;
count(column_name):统计所有非NULL行
count(*):统计所有行
用在这题很方便
