题解 | 分析客户逾期情况

SELECT pay_ability, CONCAT(ROUND(SUM(是否逾期)/COUNT(*)*100,1),'%') overdue_ratio
FROM(
SELECT l.agreement_id, l.customer_id,c.pay_ability, l.overdue_days,
(CASE  WHEN (l.overdue_days IS NULL) then 0 else 1 END) AS 是否逾期
FROM loan_tb l
INNER JOIN customer_tb c
ON l.customer_id = c.customer_id
) sub
GROUP BY pay_ability
ORDER BY overdue_ratio DESC