Sign in
apache
/
doris
/
refs/tags/1.2.3-rc01
/
.
/
regression-test
/
suites
/
tpch_unique_sql_zstd_p0
/
sql
/
q06.sql
blob: e81a352c2410e76e13440e5c536eec7f70f32422 [
file
] [
log
] [
blame
]
-- tables: lineitem
SELECT
sum
(
l_extendedprice
*
l_discount
)
AS
revenue
FROM
lineitem
WHERE
l_shipdate
>=
DATE
'1994-01-01'
AND
l_shipdate
<
DATE
'1994-01-01'
+
INTERVAL
'1'
YEAR
AND
l_discount
BETWEEN
0.06
-
0.01
AND
.06
+
0.01
AND
l_quantity
<
24