-- 第一题--
select 标识 ,count(标识) as 案件 from  ermas_case_main group by 标识;


-- 第二题 --
select 标识,count(*) from ermas_case_main group by 标识,interval(剩余本金,1000,2000,5000);

-- 第三题--
select 标识,sum(逾期总额回款)/sum(逾期总额) as 逾期总额回款率 from ermas_repay_detail as d left join ermas_case_main as m on d.合同编号=m.合同编号
group by 标识;