Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- w_state
- ,i_item_id
- ,sum(case when (cast(d_date as timestamp) < cast ('1998-04-08' as timestamp))
- then cs_sales_price - coalesce(cr_refunded_cash,0) else 0 end) as sales_before
- ,sum(case when (cast(d_date as timestamp) >= cast ('1998-04-08' as timestamp))
- then cs_sales_price - coalesce(cr_refunded_cash,0) else 0 end) as sales_after
- from
- catalog_sales left outer join catalog_returns on
- (cs_order_number = cr_order_number
- and cs_item_sk = cr_item_sk)
- ,warehouse
- ,item
- ,date_dim
- where
- i_current_price between 0.99 and 1.49
- and i_item_sk = cs_item_sk
- and cs_warehouse_sk = w_warehouse_sk
- and cs_sold_data_sk = d_date_sk
- and cast(d_date as timestamp) between (cast ('1998-04-08' as timestamp) - interval 30 days)
- and (cast ('1998-04-08' as timestamp) + interval 30 days)
- group by
- w_state,i_item_id
- order by w_state,i_item_id
- limit 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement