| ==== | |
| ---- QUERY: TPCH-Q6 | |
| # Q6 - Forecasting Revenue Change Query | |
| select | |
| sum(l_extendedprice * l_discount) as revenue | |
| from | |
| customer.c_orders.o_lineitems | |
| 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 | |
| ==== |