select 三十天内交定/进店 from(select 区域a,分部a,进店,总交定,三十天内交定,总签单 from(select "区域A",分部A,count(*) 进店 from a where 日期A BETWEEN '2022-01-01' and '2022-03-10'GROUP BY 分部a)a join(select "区域B",分部b,count(*)总交定 from B where 日期B BETWEEN'2022-01-01' and '2022-03-10'GROUP BY 分部b)bon a."分部A"=b."分部B"join(select 区域B,分部b,count(*)三十天内交定 from B where 日期B BETWEEN '2022-01-01' and '2022-03-10' and "周期B"<=30 GROUP BY 分部b)con b."分部B"=c."分部b"join(select "区域C",分部c,count(*)总签单 from c where 日期c BETWEEN '2022-01-01' and '2022-03-10'GROUP BY 分部c)don c."分部b"=d."分部C")a