This demo in the demo_app_accel/q5_simplified_100g directory implements the following query using TPC-H test data.
select
sum(l_extendedprice * (1 - l_discount)) as revenue
from
orders,
lineitem
where
l_orderkey = o_orderkey
and o_orderdate >= date '1994-01-01'
and o_orderdate < date '1995-01-01'
;