blob: 8fb41b4afdd5c1c020ca02e5b48e9569da0a0ca7 [file] [log] [blame]
====
---- QUERY: TPCH-Q14
# Q14 - Promotion Effect
select
100.00 * sum(case
when p_type like 'PROMO%'
then l_extendedprice * (1 - l_discount)
else 0.0
end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
from
lineitem,
part
where
l_partkey = p_partkey
and l_shipdate >= '1995-09-01'
and l_shipdate < '1995-10-01'
---- RESULTS
16.380779
---- TYPES
decimal
====