1. 注册数量;提交借款申请
select count(*) from agentCore.custInfo where channelid=393 and datediff(registertime,'2018-07-22')<=0; #贷款平台
select count(*) from agentCore.loanCase where channelid=393 and datediff(createtime,'2018-07-22')<=0;
2. 填写补充资料人数
select
count(*) from
(
select
a.id,
case when b.custid is not null then 1 else 0 end submitstatus
from agentCore.loanCase a
left join
agentCore.custCompleteInfo b on a.id=b.loancaseid