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 | |
} |