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_totalprice :varies
    and l_extendedprice :varies
group by
    l_orderkey, o_orderdate, o_shippriority
order by
    revenue desc,
    o_orderdate