query IRTI
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;
----
1637       164224.9253 1995-02-08  0
5191       49378.3094  1994-12-11  0
742        43728.0480  1994-12-23  0
3492       43716.0724  1994-11-24  0
2883       36666.9612  1995-01-23  0
998        11785.5486  1994-11-26  0
3430       4726.6775   1994-12-12  0
4423       3055.9365   1995-02-17  0