==== | |
---- QUERY: TPCH-Q6 | |
# Q6 - Forecasting Revenue Change Query | |
select | |
sum(l_extendedprice * l_discount) as revenue | |
from | |
lineitem | |
where | |
l_shipdate >= '1994-01-01' | |
and l_shipdate < '1995-01-01' | |
and l_discount between 0.05 and 0.07 | |
and l_quantity < 24 | |
---- RESULTS | |
123141078.2283 | |
---- TYPES | |
decimal | |
==== |