题解 | #分析客户逾期情况#

SELECT
    pay_ability,
    CONCAT(round(count(overdue_days) / count(1) * 100, 1),'%') as overdue_ratio
FROM
    loan_tb l
    LEFT JOIN customer_tb c ON l.customer_id = c.customer_id
GROUP BY
    pay_ability
order by 2 desc 

1. 连接表获取贷款信息
2. group by 获取没类信息，使用count得到占比
3. 使用concat连接字符串