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()连接,
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()连接,