message: Add benchmarks for Q1 aggregate after join, one with a filter and one without a filter
diff: @@ -64,3 +64,41 @@ string BenchmarkInfo() override {
  return "Execute the query \"SELECT SUM(l_quantity) FROM lineitem GROUP BY l_returnflag\" on SF1";
  }
  FINISH_BENCHMARK(LineitemGroupStringAggregate)
  +
  +DUCKDB_BENCHMARK(LineitemJoinAggregate, "[aggregate]")
  +void Load(DuckDBBenchmarkState *state) override {
  + // load the data into the tpch schema
  + tpch::dbgen(SF, state->db);
  +}
  +string GetQuery() override {
  + return "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, orders WHERE l_orderkey=o_orderkey GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus";
  +}
  +string VerifyResult(QueryResult *result) override {
  + if (!result->success) {
  + return result->error;
  + }
  + return string();
  +}
  +string BenchmarkInfo() override {
  + return "Execute the query \"" + GetQuery() + "\" on SF1";
  +}
  +FINISH_BENCHMARK(LineitemJoinAggregate)
  +
  +DUCKDB_BENCHMARK(LineitemJoinAggregateWithFilter, "[aggregate]")
  +void Load(DuckDBBenchmarkState *state) override {
  + // load the data into the tpch schema
  + tpch::dbgen(SF, state->db);
  +}
  +string GetQuery() override {
  + return "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, orders WHERE l_orderkey=o_orderkey AND l_shipdate <= cast('1998-09-02' AS date) GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus";
  +}
  +string VerifyResult(QueryResult *result) override {
  + if (!result->success) {
  + return result->error;
  + }
  + return string();
  +}
  +string BenchmarkInfo() override {
  + return "Execute the query \"" + GetQuery() + "\" on SF1";
  +}
  +FINISH_BENCHMARK(LineitemJoinAggregateWithFilter)
  