text: 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 o_totalprice > 11000
          and l_extendedprice < 5000
  group by
  	l_shipmode
  order by
  	l_shipmode