set timing ON time on echo on
set autot TRACE

-- Before each query, in Oracle or Tibero run: 
alter system flush shared_pool;
alter system flush buffer_cache;
exec DBMS_RESULT_CACHE.FLUSH();

select count(1)
 from tpch.h_lineitem
 where l_shipdate >= date '1996-01-01';

select count(o_orderkey)
from tpch.h_order
where o_totalprice between 100000 and 200000;

select sum(l_extendedprice * l_discount) as revenue
from tpch.h_lineitem
where l_shipdate >= date '1996-01-01'
and l_shipdate < date '1996-01-01' + interval '1' year
and l_discount between 0.06 - 0.01
and 0.06 + 0.01 and l_quantity < 24;

select sum(l_extendedprice * (1 - l_discount)) as promo_revenue
from tpch.h_lineitem, tpch.h_part
where l_partkey = p_partkey
and l_shipdate >= date '1994-09-01'
and l_shipdate < date '1994-09-01' + interval '1' month;

UPDATE tpch.h_lineitem
SET l_discount = 0.22
WHERE l_discount = 0.02;

rollback; -- rollback time should be considered separately.

DELETE FROM tpch.h_lineitem
where l_shipdate <= date '1996-01-01'
and l_shipdate > date '1992-01-01' + interval '1' year;

rollback; -- rollback time should be considered separately.