56,677
社区成员
发帖
与我相关
我的任务
分享
select
date_sub(curdate(),interval 7 day) 截止上传日期
,count(pt.id) 累计上传数
from call_service_db.presale_task pt
where pt.create_time<date_sub(curdate(),interval 6 day)
union all
select
date_sub(curdate(),interval 6 day) 截止上传日期
,count(pt.id) 累计上传数
from call_service_db.presale_task pt
where pt.create_time<date_sub(curdate(),interval 5 day)
union all
select
date_sub(curdate(),interval 5 day) 截止上传日期
,count(pt.id) 累计上传数
from call_service_db.presale_task pt
where pt.create_time<date_sub(curdate(),interval 4 day)
union all
select
date_sub(curdate(),interval 4 day) 截止上传日期
,count(pt.id) 累计上传数
from call_service_db.presale_task pt
where pt.create_time<date_sub(curdate(),interval 3 day)
union all
select
date_sub(curdate(),interval 3 day) 截止上传日期
,count(pt.id) 累计上传数
from call_service_db.presale_task pt
where pt.create_time<date_sub(curdate(),interval 2 day)
union all
select
date_sub(curdate(),interval 2 day) 截止上传日期
,count(pt.id) 累计上传数
from call_service_db.presale_task pt
where pt.create_time<date_sub(curdate(),interval 1 day)