0001 SELECT sum(ws_ext_discount_amt) AS `Excess Discount Amount `
0002 FROM web_sales, item, date_dim
0003 WHERE i_manufact_id = 350
0004 AND i_item_sk = ws_item_sk
0005 AND d_date BETWEEN '2000-01-27' AND (cast('2000-01-27' AS DATE) + INTERVAL 90 days)
0006 AND d_date_sk = ws_sold_date_sk
0007 AND ws_ext_discount_amt >
0008 (
0009 SELECT 1.3 * avg(ws_ext_discount_amt)
0010 FROM web_sales, date_dim
0011 WHERE ws_item_sk = i_item_sk
0012 AND d_date BETWEEN '2000-01-27' AND (cast('2000-01-27' AS DATE) + INTERVAL 90 days)
0013 AND d_date_sk = ws_sold_date_sk
0014 )
0015 ORDER BY sum(ws_ext_discount_amt)
0016 LIMIT 100
