message: For now manually rewrite average to sum/count in q01 integer keys
diff: @@ -39,7 +39,28 @@ SELECT l_orderkey,
  FROM lineitem_normal;
  run
  -PRAGMA tpch(1);
  +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,
  + sum(l_quantity) / count(l_quantity) AS avg_qty,
  + sum(l_extendedprice) / count(l_extendedprice) AS avg_price,
  + sum(l_discount) / count(l_discount) AS avg_disc,
  + count(*) AS count_order
  +FROM
  + lineitem
  +WHERE
  + l_shipdate <= CAST('1998-09-02' AS date)
  +GROUP BY
  + l_returnflag,
  + l_linestatus
  +ORDER BY
  + l_returnflag,
  + l_linestatus;
  +
  result IIIIIIIIII
  0 0 37734107 56586554400.73 53758257134.8700 55909065222.827692 25.5220 38273.1297 0.0500 1478493
  