深圳智汇创想科技有限公司

运营利润报表，店铺：Amazon-Z01126-US，三月份，退款金额和退款数量不对

[步骤]

[结果]

[期望]

select sum(quantity),sum(total)
from sh_logic.fact_order_info om
join sh_logic.fact_order_list od on om.order_code = od.order_code
 and om.order_source_dwid = od.order_source_dwid
 and om.customer_dwid = od.customer_dwid
join (select source_dwid,order_code,msku from sh_logic.fact_financial_events 
where type_code = 5
and settlement_time >= to_date('20220301','YYYYMMDD HH24:MI:SS')
and settlement_time <= to_date('20220331 23:59:59','YYYYMMDD HH24:MI:SS')
group by source_dwid,order_code,msku
)fe1 on om.seller_order_code = fe1.order_code
 and od.msku = fe1.msku
 and od.order_source_dwid = fe1.source_dwid
join sh_logic.fact_financial_events fe 
  on fe1.order_code = fe.order_code
 and fe1.msku = fe.msku
 and fe1.source_dwid = fe.source_dwid
where om.is_pay = 1 --已支付
  --and om.create_time_day = 20220101
  and om.order_source_dwid = 1693
  and om.create_time >= to_date('20220301','YYYYMMDD HH24:MI:SS')
  and om.create_time <= to_date('20220331 23:59:59','YYYYMMDD HH24:MI:SS');---退款金额和退款数量