销售数据

按支付方式统计销售

select o.pos_no,
       t.tender_type_id,
       t.tender_type_desc,
       sum((case
             when o.value_sign = 'N' then
              -nvl(o.real_value, o.value_)
             else
              nvl(o.real_value, o.value_)
           end)) sale
  from h_t_order o, h_t_order_pay p, mom_tender t
 where o.id = p.o_id
   and p.tender_type_id = t.tender_type_id
   and o.belong_date between 20230101 and 20231231
 group by o.pos_no, t.tender_type_id, t.tender_type_desc