题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
SELECT pay_ability,
CONCAT(round((100*sum(yuqi)/count(customer_id)),1),'%') AS overdue_ratio
FROM (select sum(case when overdue_days>=1 then 1 else 0 end ) as yuqi,
pay_ability,
customer_id
from loan_tb lt
left join customer_tb as ct using(customer_id)
group by customer_id ) TEMP1
GROUP BY pay_ability
ORDER BY overdue_ratio DESC
⑨✌们拿它练练面试愣是给他整出幻觉了
