金融服务各分期申请数统计

原创

qq5965f3c101045 2022-06-05 01:17:22 ©著作权

文章标签 Java 文章分类 Java 后端开发

©著作权归作者所有：来自51CTO博客作者qq5965f3c101045的原创作品，请联系作者获取转载授权，否则将追究法律责任

/*2017年三月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 三月份申请数 from LoanApply where MoneyCheckTime>'2017-3-1 00:00:00' and MoneyCheckTime<'2017-4-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年四月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 四月份申请数 from LoanApply where MoneyCheckTime>'2017-4-1 00:00:00' and MoneyCheckTime<'2017-5-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年五月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 五月份申请数 from LoanApply where MoneyCheckTime>'2017-5-1 00:00:00' and MoneyCheckTime<'2017-6-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年六月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 六月份申请数 from LoanApply where MoneyCheckTime>'2017-6-1 00:00:00' and MoneyCheckTime<'2017-7-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年七月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 七月份申请数 from LoanApply where MoneyCheckTime>'2017-7-1 00:00:00' and MoneyCheckTime<'2017-8-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年八月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 五月份申请数 from LoanApply where MoneyCheckTime>'2017-8-1 00:00:00' and MoneyCheckTime<'2017-9-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年九月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 九月份申请数 from LoanApply where MoneyCheckTime>'2017-9-1 00:00:00' and MoneyCheckTime<'2017-10-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年十月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 十月份申请数 from LoanApply where MoneyCheckTime>'2017-10-1 00:00:00' and MoneyCheckTime<'2017-11-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年十一月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 十一月份申请数 from LoanApply where MoneyCheckTime>'2017-11-1 00:00:00' and MoneyCheckTime<'2017-12-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年十二月份各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 十二月份申请数 from LoanApply where MoneyCheckTime>'2017-12-1 00:00:00' and MoneyCheckTime<'2018-1-1 00:00:00'  group by LoanApply.BankNeedInfos  
/*2017年各分期申请数统计*/
select substring(BankNeedInfos,52,2) as 期数 ,COUNT(*) as 十二月份申请数 from LoanApply where MoneyCheckTime>'2017-1-1 00:00:00' and MoneyCheckTime<'2018-1-1 00:00:00'  group by LoanApply.BankNeedInfos