题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
SELECT pay_ability,
CONCAT(ROUND(COUNT(IF(overdue_days IS NOT NULL, overdue_days, NULL)) / COUNT(1) * 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;
作业帮二面29人在聊
查看27道真题和解析
投递蓝禾技术等公司10个岗位 >