0001 SELECT
0002 ss_customer_sk,
0003 sum(act_sales) sumsales
0004 FROM (SELECT
0005 ss_item_sk,
0006 ss_ticket_number,
0007 ss_customer_sk,
0008 CASE WHEN sr_return_quantity IS NOT NULL
0009 THEN (ss_quantity - sr_return_quantity) * ss_sales_price
0010 ELSE (ss_quantity * ss_sales_price) END act_sales
0011 FROM store_sales
0012 LEFT OUTER JOIN store_returns
0013 ON (sr_item_sk = ss_item_sk AND sr_ticket_number = ss_ticket_number)
0014 ,
0015 reason
0016 WHERE sr_reason_sk = r_reason_sk AND r_reason_desc = 'reason 28') t
0017 GROUP BY ss_customer_sk
0018 ORDER BY sumsales, ss_customer_sk
0019 LIMIT 100
