TPC-H Q14

/* using 19620718 as a seed to the RNG */
SELECT
  100.00 * SUM(
    CASE
      WHEN p_type LIKE 'PROMO%'
      THEN l_extendedprice * (
        1 - l_discount
      )
      ELSE 0
    END
  ) / SUM(l_extendedprice * (
    1 - l_discount
  )) AS promo_revenue
FROM lineitem, part
WHERE
  l_partkey = p_partkey
  AND l_shipdate >= CAST('1996-04-01' AS DATE)
  AND l_shipdate < DATEADD(MONTH, 1, CAST('1996-04-01' AS DATE));