题解 | 分析客户逾期情况

SELECT pay_ability, CONCAT(ROUND(SUM(overdue)/COUNT(overdue)*100, 1), '%') overdue_ratio
FROM(
SELECT loan_tb.customer_id, pay_ability, CASE WHEN overdue_days IS NULL THEN 0 else 1 END overdue
FROM loan_tb 
JOIN customer_tb ON loan_tb.customer_id = customer_tb.customer_id
) sub_query
GROUP BY pay_ability
ORDER BY overdue_ratio DESC