text: -- database: presto; groups: tpch; tables: lineitem
  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 <= '1998-09-02'
  GROUP BY
  l_returnflag,
  l_linestatus
  ORDER BY
  l_returnflag,
  l_linestatus
  