query TTRRRRRRRI
select
    l_returnflag,
    l_linestatus,
    sum(l_quantity) as sum_qty,
    sum(l_extendedprice) as sum_base_price,
    sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
    sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
    avg(l_quantity) as avg_qty,
    avg(l_extendedprice) as avg_price,
    avg(l_discount) as avg_disc,
    count(*) as count_order
from
    lineitem
where
    l_shipdate <= date '1998-12-01' - interval '71' day
group by
    l_returnflag,
    l_linestatus
order by
    l_returnflag,
    l_linestatus;
----
A  F  37474  37569624.64  35676192.0970  37101416.222424  25.354533152909336941813261164  25419.231826792963464140730717  0.0508660351826792963464140731  1478
N  F  1041   1041301.07   999060.8980    1036450.802280   27.394736842105263157894736842  27402.659736842105263157894737  0.0428947368421052631578947368  38
N  O  75823  76040604.76  72270477.1588  75140545.284463  25.564059339177343223196223871  25637.425745111260957518543493  0.0498246797033041132838840189  2966
R  F  36511  36570841.24  34738472.8758  36169060.112193  25.059025394646533973919011668  25100.096938915579958819492107  0.0500274536719286204529855868  1457