framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query6.sql

SELECT
  SUM(L_EXTENDEDPRICE * L_DISCOUNT) AS REVENUE
FROM
  lineitem
WHERE
  L_SHIPDate >= DATE '1997-01-01'
  AND L_SHIPDate < CAST((DATE '1997-01-01' + INTERVAL '1' YEAR) AS DATE)
  AND
  L_DISCOUNT BETWEEN 0.03 - 0.01 AND 0.03 + 0.01
  AND L_QUANTITY < 24;