text: SET SCHEMA TPCH;
  elapsedtime on;
  -- QUERY 12
  select
  	l_shipmode,
  	sum(case
  		when o_orderpriority = '1-URGENT'
  			or o_orderpriority = '2-HIGH'
  			then 1
  		else 0
  	end) as high_line_count,
  	sum(case
  		when o_orderpriority <> '1-URGENT'
  			and o_orderpriority <> '2-HIGH'
  			then 1
  		else 0
  	end) as low_line_count
  from
  	orders,
  	lineitem
  where
  	o_orderkey = l_orderkey
  	and l_shipmode in ('MAIL', 'SHIP')
  	and l_commitdate < l_receiptdate
  	and l_shipdate < l_commitdate
          and l_receiptdate >= date('1994-01-01')
          and l_receiptdate < date({fn TIMESTAMPADD(SQL_TSI_YEAR, 1, cast('1994-01-01 00:00:00' as timestamp))})
  group by
  	l_shipmode
  order by
  	l_shipmode
  -- END OF QUERY
  ;
  