asterix-benchmarks/src/main/resources/tpc-h/queries/q06_forecast_revenue_change.3.query.aql

use dataverse tpch;

let $revenue := sum(
  for $l in dataset('LineItem')
  where $l.l_shipdate >= '1994-01-01'
    and $l.l_shipdate < '1995-01-01'
    and $l.l_discount >= 0.05 and $l.l_discount <= 0.07
    and $l.l_quantity < 24
  return $l.l_extendedprice * $l.l_discount
)
return {
  "revenue": $revenue
}