17,090
社区成员
发帖
与我相关
我的任务
分享
select region,
(select sum(no),sum(square),sum(income_lost) from t t2 where t1.region=t2.region and date<3个月的),
(select sum(no),sum(square),sum(income_lost) from t t2 where t1.region=t2.region and date<6个月的),
...
from t t1