0001 SELECT 1 AS `excess discount amount `
0002 FROM
0003 catalog_sales, item, date_dim
0004 WHERE
0005 i_manufact_id = 977
0006 AND i_item_sk = cs_item_sk
0007 AND d_date BETWEEN '2000-01-27' AND (cast('2000-01-27' AS DATE) + interval 90 days)
0008 AND d_date_sk = cs_sold_date_sk
0009 AND cs_ext_discount_amt > (
0010 SELECT 1.3 * avg(cs_ext_discount_amt)
0011 FROM catalog_sales, date_dim
0012 WHERE cs_item_sk = i_item_sk
0013 AND d_date BETWEEN '2000-01-27' AND (cast('2000-01-27' AS DATE) + interval 90 days)
0014 AND d_date_sk = cs_sold_date_sk)
0015 LIMIT 100
