题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
SELECT ct.pay_ability pay_ability, CONCAT( ROUND( count( lt.overdue_days )/ COUNT( ct.customer_id )* 100, 1 ), '%' ) overdue_ratio FROM loan_tb lt RIGHT JOIN customer_tb ct ON lt.customer_id = ct.customer_id GROUP BY ct.pay_ability ORDER BY overdue_ratio DESC
