数据统计脚本（一周）

1. 注册数量；提交借款申请

select count(*) from  agentCore.custInfo where channelid=393 and datediff(registertime,'2018-07-16')>=0 and datediff(registertime,'2018-07-22')<=0; 
select count(*) from  agentCore.loanCase where channelid=393 and datediff(createtime,'2018-07-16')>=0 and datediff(createtime,'2018-07-22')<=0;

2. 填写补充资料人数

select 
count(*) from
(