题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select c.pay_ability pay_ability, CONCAT(round(count(overdue_days)/count(*) * 100, 1), '%') 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;
投递字节跳动等公司8个岗位 >
像我们这种二本仔秋招没有实习也是白忙活
