题解 | 分析客户逾期情况

SELECT pay_ability,
CONCAT(ROUND(SUM(IF(overdue_days IS NOT NULL,1,0))*100/COUNT(pay_ability),1),'%') AS overdue_ratio
FROM loan_tb JOIN customer_tb USING(customer_id)
GROUP BY pay_ability
ORDER BY overdue_ratio DESC;

注意别忘了乘以100