Sign in
apache
/
tajo
/
e1bd549dd79aa779e417c58b44421aa0b39bb1e9
/
.
/
tajo-core
/
benchmark
/
tpch
/
q17.sql
blob: d67a39957e1a54f3ecab96284196b05d944025de [
file
] [
log
] [
blame
]
select
sum
(
l_extendedprice
)
/
7.0
as
avg_yearly
from
lineitem
,
part
where
p_partkey
=
l_partkey
and
p_brand
=
'Brand#23'
and
p_container
=
'MED BOX'
and
l_quantity
<
(
select
0.2
*
avg
(
l_quantity
)
from
lineitem
where
l_partkey
=
p_partkey
)