E. Test Queries : Query 3
 
Share this page                  
Query 3
select first 10
l_orderkey
,sum(l_extendedprice * (1 - l_discount)) as revenue
,o_orderdate
,o_shippriority
from
customer2
,orders2
,lineitem2
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;