TPC-H Q6

/* using 19620718 as a seed to the RNG */
SELECT
  SUM(l_extendedprice * l_discount) AS revenue
FROM lineitem
WHERE
  l_shipdate >= CAST('1993-01-01' AS DATE)
  AND l_shipdate < DATEADD(YEAR, 1, CAST('1993-01-01' AS DATE))
  AND l_discount BETWEEN 0.03 - 0.01 AND 0.03 + 0.01
  AND l_quantity < 24;