web | Java

基于借据表,统计SQL 逾期90天以上(户数、余额、逾期率)

千锋教育

select count(distinct uid) 


`户数`,sum(balance) 


`余额`,round((sum(90day) / count(*)),2) 


`逾期率` from ( select uid, balance, case when owerduedays > 90 then 1 else 0 `90day` from jieju ) t1