select pay_ability, concat(round(count(overdue_days)/count(customer_id)*100,1),'%') as overdue_ratio
from customer_tb
join loan_tb using(customer_id)
group by pay_ability
order by overdue_ratio desc

问题关键是百分数形式,用concat()连接,