题解 | 分析客户逾期情况

# 分析各还款能力级别的客户逾期情况，按照还款能力级别统计有逾期行为客户占比。要求输出:还款能力级别、逾期客户占比。
# 注：逾期客户占比要求按照百分数形式输出并四舍五入保留 1 位小数，最终结果按照占比降序排序。
with cte as(
select pay_ability,customer_id,if(max(overdue_days)>0,1,0) as overdue
from customer_tb a left join  loan_tb b using(customer_id)
group by pay_ability,customer_id )
select pay_ability,concat(round(ifnull(avg(overdue),0)*100,1),"%") as overdue_ratio
from cte
group by pay_ability
order by ifnull(avg(overdue),0) desc