text: SET SCHEMA ##SCHEMA##;
  elapsedtime on;
  -- QUERY 03
  ##EXPLAIN##
  select
  	l_orderkey,
  	sum(l_extendedprice * (1 - l_discount)) as revenue,
  	o_orderdate,
  	o_shippriority
  from
  	customer,
  	orders,
  	lineitem
  where
  	c_mktsegment = 'BUILDING' 
  	and c_custkey = o_custkey
  	and l_orderkey = o_orderkey
  	and o_orderdate < date('1995-03-15') 
  	and l_shipdate > date('1995-03-15') 
  group by
  	l_orderkey,
  	o_orderdate,
  	o_shippriority
  order by
  	revenue desc,
  	o_orderdate 
  {limit 10}
  -- END OF QUERY
  ;
  