concat()实现字符串拼接
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select
ct.pay_ability,
concat(
round(sum(if(lt.overdue_days is not null, 1, 0)) / count(*) * 100,1),'%'
) overdue_ratio
from
loan_tb lt
left join customer_tb ct on lt.customer_id = ct.customer_id
group by
ct.pay_ability
order by
2 desc
查看6道真题和解析