TPC-DS Q32

SELECT
TOP 100
  SUM(cs_ext_discount_amt) AS [excess discount amount]
FROM catalog_sales, item, date_dim
WHERE
  i_manufact_id = 648
  AND i_item_sk = cs_item_sk
  AND d_date BETWEEN '2002-02-11' AND (
    DATEADD(DAY, 90, CAST('2002-02-11' AS DATE))
  )
  AND d_date_sk = cs_sold_date_sk
  AND cs_ext_discount_amt > (
    SELECT
      1.3 * AVG(cs_ext_discount_amt)
    FROM catalog_sales, date_dim
    WHERE
      cs_item_sk = i_item_sk
      AND d_date BETWEEN '2002-02-11' AND (
        DATEADD(DAY, 90, CAST('2002-02-11' AS DATE))
      )
      AND d_date_sk = cs_sold_date_sk
  );