Init tables ...
Init tables ...Ok
Query03:
Query text:
SELECT AVG(UserID) FROM `olap_yatests/clickbench/hits`

	iteration 0:	ok	0.218988s seconds

Results for 1 iterations
┌─────────┬──────────┬─────────┬─────────┬─────────┬─────────┬───────────┬─────────┬─────────┬─────────┬─────────┬────────────────┬────────────────┬────────────────┬───────────┬──────────────┬────────────┬────────────┐
│ Query # │ ColdTime │ Min     │ Max     │ Mean    │ Median  │ UnixBench │ Std     │ RttMin  │ RttMax  │ RttAvg  │ CompilationMin │ CompilationMax │ CompilationAvg │ GrossTime │ SuccessCount │ FailsCount │ DiffsCount │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query03 │   0.204  │   0.204 │   0.204 │   0.204 │   0.203 │   0.204   │   0.001 │   0.015 │   0.015 │   0.015 │   0.079        │   0.079        │   0.079        │   0.219   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Sum     │   0.204  │   0.204 │   0.204 │   0.204 │   0.203 │   0.204   │   0.000 │   0.015 │   0.015 │   0.015 │   0.079        │   0.079        │   0.080        │   0.309   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Avg     │   0.204  │   0.204 │   0.204 │   0.204 │   0.203 │   0.204   │   0.000 │   0.015 │   0.015 │   0.015 │   0.079        │   0.079        │   0.080        │   0.309   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ GAvg    │   0.204  │   0.204 │   0.204 │   0.204 │   0.203 │   0.204   │   0.000 │   0.015 │   0.015 │   0.001 │   0.079        │   0.079        │   0.001        │   0.000   │ 1            │            │            │
└─────────┴──────────┴─────────┴─────────┴─────────┴─────────┴───────────┴─────────┴─────────┴─────────┴─────────┴────────────────┴────────────────┴────────────────┴───────────┴──────────────┴────────────┴────────────┘

Results saved to Query03.result
Json report saved to Query03.stats.json
Fill table call_center...
Fill table call_center OK 1 / 1 (0.142553s)
Fill table catalog_page...
Fill table catalog_page OK 1171 / 1171 (0.150213s)
Fill table catalog_sales...
Fill table catalog_sales OK 16000 / 16000 (4.223643s)
Fill table customer...
Fill table customer OK 10000 / 10000 (0.315217s)
Fill table customer_address...
Fill table customer_address OK 5000 / 5000 (0.266604s)
Fill table customer_demographics...
Fill table customer_demographics OK 192080 / 192080 (1.526293s)
Fill table date_dim...
Fill table date_dim OK 7304 / 7304 (0.279953s)
Fill table household_demographics...
Fill table household_demographics OK 720 / 720 (0.117487s)
Fill table income_band...
Fill table income_band OK 2 / 2 (0.111255s)
Fill table inventory...
Fill table inventory OK 1174500 / 1174500 (6.239608s)
Fill table item...
Fill table item OK 1800 / 1800 (0.298500s)
Fill table promotion...
Fill table promotion OK 30 / 30 (0.107874s)
Fill table reason...
Fill table reason OK 3 / 3 (0.104870s)
Fill table ship_mode...
Fill table ship_mode OK 2 / 2 (0.107029s)
Fill table store...
Fill table store OK 1 / 1 (0.115654s)
Fill table store_sales...
Fill table store_sales OK 24000 / 24000 (3.848482s)
Fill table time_dim...
Fill table time_dim OK 8640 / 8640 (0.143064s)
Fill table warehouse...
Fill table warehouse OK 1 / 1 (0.105447s)
Fill table web_page...
Fill table web_page OK 6 / 6 (0.105906s)
Fill table web_sales...
Fill table web_sales OK 6000 / 6000 (2.048079s)
Fill table web_site...
Fill table web_site OK 3 / 3 (0.110272s)
Query01:
Query text:
$z1_2_35 = 1.2;
$customer_total_return =
(select a.sr_customer_sk as ctr_customer_sk
,a.sr_store_sk as ctr_store_sk
,sum(a.sr_return_amt) as ctr_total_return
from `olap_yatests/tpcds/s1/store_returns` as a cross join `olap_yatests/tpcds/s1/date_dim` as b
where sr_returned_date_sk = d_date_sk
and d_year =2000
group by a.sr_customer_sk
,a.sr_store_sk);
$avg_total_returns = (
    select ctr_store_sk, avg(ctr_total_return)*$z1_2_35 as ctr_avg
    from $customer_total_return
    group by ctr_store_sk
);
 select  c_customer_id
from $customer_total_return ctr1
cross join `olap_yatests/tpcds/s1/store`
cross join `olap_yatests/tpcds/s1/customer`
join $avg_total_returns ctr2 on ctr1.ctr_store_sk = ctr2.ctr_store_sk
where ctr_total_return > ctr_avg
and s_store_sk = ctr1.ctr_store_sk
and s_state = 'TN'
and ctr_customer_sk = c_customer_sk
order by c_customer_id
limit 100;

	iteration 0:	ok	0.664025s seconds

Results for 1 iterations
┌─────────┬──────────┬─────────┬─────────┬─────────┬─────────┬───────────┬─────────┬─────────┬─────────┬─────────┬────────────────┬────────────────┬────────────────┬───────────┬──────────────┬────────────┬────────────┐
│ Query # │ ColdTime │ Min     │ Max     │ Mean    │ Median  │ UnixBench │ Std     │ RttMin  │ RttMax  │ RttAvg  │ CompilationMin │ CompilationMax │ CompilationAvg │ GrossTime │ SuccessCount │ FailsCount │ DiffsCount │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query01 │   0.641  │   0.641 │   0.641 │   0.641 │   0.641 │   0.641   │   0.000 │   0.023 │   0.023 │   0.023 │   0.505        │   0.505        │   0.505        │   0.664   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Sum     │   0.641  │   0.641 │   0.641 │   0.641 │   0.641 │   0.641   │   0.000 │   0.023 │   0.023 │   0.023 │   0.505        │   0.505        │   0.506        │   1.203   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Avg     │   0.641  │   0.641 │   0.641 │   0.641 │   0.641 │   0.641   │   0.000 │   0.023 │   0.023 │   0.023 │   0.505        │   0.505        │   0.506        │   1.203   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ GAvg    │   0.641  │   0.641 │   0.641 │   0.641 │   0.641 │   0.641   │   0.000 │   0.023 │   0.023 │   0.001 │   0.505        │   0.505        │   0.001        │   0.000   │ 1            │            │            │
└─────────┴──────────┴─────────┴─────────┴─────────┴─────────┴───────────┴─────────┴─────────┴─────────┴─────────┴────────────────┴────────────────┴────────────────┴───────────┴──────────────┴────────────┴────────────┘

Results saved to Query01.result
Json report saved to Query01.stats.json
Remove path e1...
Remove path e1...Ok
Remove path olap_yatests...
Remove path olap_yatests...Ok
Query05:
Query text:
$z1_12 = 1;
$border = Date("1994-01-01");
$j1 = (
select
    n.n_name as n_name,
    n.n_nationkey as n_nationkey
from
    `upload/tpch/s0.1/nation` as n
join
    `upload/tpch/s0.1/region` as r
on
    n.n_regionkey = r.r_regionkey
where
    r_name = 'ASIA'
);
$j2 = (
select
    j.n_name as n_name,
    j.n_nationkey as n_nationkey,
    s.s_suppkey as s_suppkey
from
    `upload/tpch/s0.1/supplier` as s
join
    $j1 as j
on
    j.n_nationkey = s.s_nationkey
);
$j3 = (
select
    j.n_name as n_name,
    j.n_nationkey as n_nationkey,
    l.l_extendedprice as l_extendedprice,
    l.l_discount as l_discount,
    l.l_orderkey as l_orderkey
from
    `upload/tpch/s0.1/lineitem` as l
join
    $j2 as j
on
    l.l_suppkey = j.s_suppkey
);
$j4 = (
select
    o.o_orderkey as o_orderkey,
    c.c_nationkey as c_nationkey
from
    `upload/tpch/s0.1/orders` as o
join
    `upload/tpch/s0.1/customer` as c
on
    c.c_custkey = o.o_custkey
where
    o.o_orderdate >= $border
    and o.o_orderdate < ($border + Interval("P365D"))
);
$j5 = (
select
    j3.n_name as n_name,
    j3.l_extendedprice as l_extendedprice,
    j3.l_discount as l_discount
from
    $j3 as j3
join
    $j4 as j4
on
    j3.n_nationkey = j4.c_nationkey
    and j3.l_orderkey = j4.o_orderkey
);
select
    n_name,
    sum(l_extendedprice * ($z1_12 - l_discount)) as revenue
from
    $j5
group by
    n_name
order by
    revenue desc;

	iteration 0:	ok	1.637989s seconds
	iteration 1:	ok	1.080900s seconds
	iteration 2:	ok	0.989517s seconds

Results for 3 iterations
┌─────────┬──────────┬─────────┬─────────┬─────────┬─────────┬───────────┬─────────┬─────────┬─────────┬─────────┬────────────────┬────────────────┬────────────────┬───────────┬──────────────┬────────────┬────────────┐
│ Query # │ ColdTime │ Min     │ Max     │ Mean    │ Median  │ UnixBench │ Std     │ RttMin  │ RttMax  │ RttAvg  │ CompilationMin │ CompilationMax │ CompilationAvg │ GrossTime │ SuccessCount │ FailsCount │ DiffsCount │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query05 │   1.496  │   0.889 │   1.496 │   1.129 │   1.001 │   0.944   │   0.264 │   0.079 │   0.142 │   0.107 │   0.000        │   0.474        │   0.158        │   3.708   │ 3            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Sum     │   1.496  │   0.889 │   1.496 │   1.129 │   1.001 │   0.944   │   0.000 │   0.079 │   0.142 │   0.107 │   0.000        │   0.474        │   0.159        │   4.261   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Avg     │   1.496  │   0.889 │   1.496 │   1.129 │   1.001 │   0.944   │   0.000 │   0.079 │   0.142 │   0.107 │   0.000        │   0.474        │   0.159        │   4.261   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ GAvg    │   1.496  │   0.889 │   1.496 │   1.129 │   1.001 │   0.944   │   0.000 │   0.079 │   0.142 │   0.001 │   0.000        │   0.474        │   0.001        │   0.000   │ 1            │            │            │
└─────────┴──────────┴─────────┴─────────┴─────────┴─────────┴───────────┴─────────┴─────────┴─────────┴─────────┴────────────────┴────────────────┴────────────────┴───────────┴──────────────┴────────────┴────────────┘

Results saved to Query05.result
Json report saved to Query05.stats.json
Query01:
Query text:
$z1_12 = 1;
select
    l_returnflag,
    l_linestatus,
    sum(l_quantity) as sum_qty,
    sum(l_extendedprice) as sum_base_price,
    sum(l_extendedprice * ($z1_12 - l_discount)) as sum_disc_price,
    sum(l_extendedprice * ($z1_12 - l_discount) * ($z1_12 + 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
    `olap_yatests/tpch/s0_1/lineitem`
where
    l_shipdate <= Date('1998-12-01') - Interval("P90D")
group by
    l_returnflag,
    l_linestatus
order by
    l_returnflag,
    l_linestatus;

	iteration 0:	ok	2.621282s seconds
Query02:
Query text:
$r = (
select
    r_regionkey
from 
    `olap_yatests/tpch/s0_1/region`
where
    r_name='EUROPE'
);
$n = (
select
    n_name,
    n_nationkey
from
    `olap_yatests/tpch/s0_1/nation` as n 
left semi join
    $r as r
on 
    n.n_regionkey = r.r_regionkey
);
$s1 = (
select
    s_suppkey
from
    `olap_yatests/tpch/s0_1/supplier` as s
left semi join
    $n as n
on
    s.s_nationkey = n.n_nationkey
);
$min_ps_supplycost = (
select
    min(ps_supplycost) as min_ps_supplycost,
    ps.ps_partkey as ps_partkey
from
    `olap_yatests/tpch/s0_1/partsupp` as ps
left semi join
    $s1 as s
on
    ps.ps_suppkey = s.s_suppkey
group by
    ps.ps_partkey
);
$p = (
select
    p_partkey,
    p_mfgr
from
    `olap_yatests/tpch/s0_1/part`
where
    p_size = 15
    and p_type like '%BRASS'
);
$ps = (
select
    ps.ps_partkey as ps_partkey,
    p.p_mfgr as p_mfgr,
    ps.ps_supplycost as ps_supplycost,
    ps.ps_suppkey as ps_suppkey
from
    `olap_yatests/tpch/s0_1/partsupp` as ps
join
    $p as p
on
    p.p_partkey = ps.ps_partkey
);
$s2 = (
select
    s_acctbal,
    s_name,
    s_address,
    s_phone,
    s_comment,
    s_suppkey,
    n_name
from
    `olap_yatests/tpch/s0_1/supplier` as s
join
    $n as n
on
    s.s_nationkey = n.n_nationkey
);
$jp =(
select
    ps_partkey,
    ps_supplycost,
    p_mfgr,
    s_acctbal,
    s_name,
    s_address,
    s_phone,
    s_comment,
    n_name
from
    $ps as ps
join    
    $s2 as s
on
    ps.ps_suppkey = s.s_suppkey  
);
select
    s_acctbal,
    s_name,
    n_name,
    jp.ps_partkey as p_partkey,
    p_mfgr,
    s_address,
    s_phone,
    s_comment
from
    $jp as jp
join
    $min_ps_supplycost as m
on
    jp.ps_partkey = m.ps_partkey
where
    min_ps_supplycost = ps_supplycost
order by
    s_acctbal desc,
    n_name,
    s_name,
    p_partkey
limit 100;

	iteration 0:	ok	3.456472s seconds
Query03:
Query text:
$z1_12 = 1;
$round = ($x, $y) -> { return Math::Round($x, $y); };
$c = (
select
    c_custkey
from
    `olap_yatests/tpch/s0_1/customer`
where
    c_mktsegment = 'BUILDING'
);
$o = (
select
    o_orderdate,
    o_shippriority,
    o_orderkey
from
    `olap_yatests/tpch/s0_1/orders` as o
left semi join
    $c as c
on
    c.c_custkey = o.o_custkey
where
    o_orderdate < Date('1995-03-15')
);
$join2 = (
select
    o.o_orderdate as o_orderdate,
    o.o_shippriority as o_shippriority,
    l.l_orderkey as l_orderkey,
    l.l_discount as l_discount,
    l.l_extendedprice as l_extendedprice
from
    `olap_yatests/tpch/s0_1/lineitem` as l
join
    $o as o
on
    l.l_orderkey = o.o_orderkey
where
    l_shipdate > Date('1995-03-15')
);
select
    l_orderkey,
    $round(sum(l_extendedprice * ($z1_12 - l_discount)), -3) as revenue,
    o_orderdate,
    o_shippriority
from
    $join2
group by
    l_orderkey,
    o_orderdate,
    o_shippriority
order by
    revenue desc,
    o_orderdate,
    l_orderkey
limit 10;

	iteration 0:	ok	4.616277s seconds
Query04:
Query text:
$border = Date("1993-07-01");
$o = (
select
    o_orderpriority,
    o_orderkey
from
    `olap_yatests/tpch/s0_1/orders`
where
    o_orderdate >= $border
    and o_orderdate < DateTime::MakeDate(DateTime::ShiftMonths($border, 3))
);
$l = (
select
    distinct l_orderkey
from
    `olap_yatests/tpch/s0_1/lineitem`
where
    l_commitdate < l_receiptdate
);
select
    o.o_orderpriority as o_orderpriority,
    count(*) as order_count
from
    $o as o
join
    $l as l
on
    o.o_orderkey = l.l_orderkey
group by
    o.o_orderpriority
order by
    o_orderpriority;

	iteration 0:	ok	4.768513s seconds
Query05:
Query text:
$z1_12 = 1;
$border = Date("1994-01-01");
$j1 = (
select
    n.n_name as n_name,
    n.n_nationkey as n_nationkey
from
    `olap_yatests/tpch/s0_1/nation` as n
join
    `olap_yatests/tpch/s0_1/region` as r
on
    n.n_regionkey = r.r_regionkey
where
    r_name = 'ASIA'
);
$j2 = (
select
    j.n_name as n_name,
    j.n_nationkey as n_nationkey,
    s.s_suppkey as s_suppkey
from
    `olap_yatests/tpch/s0_1/supplier` as s
join
    $j1 as j
on
    j.n_nationkey = s.s_nationkey
);
$j3 = (
select
    j.n_name as n_name,
    j.n_nationkey as n_nationkey,
    l.l_extendedprice as l_extendedprice,
    l.l_discount as l_discount,
    l.l_orderkey as l_orderkey
from
    `olap_yatests/tpch/s0_1/lineitem` as l
join
    $j2 as j
on
    l.l_suppkey = j.s_suppkey
);
$j4 = (
select
    o.o_orderkey as o_orderkey,
    c.c_nationkey as c_nationkey
from
    `olap_yatests/tpch/s0_1/orders` as o
join
    `olap_yatests/tpch/s0_1/customer` as c
on
    c.c_custkey = o.o_custkey
where
    o.o_orderdate >= $border
    and o.o_orderdate < ($border + Interval("P365D"))
);
$j5 = (
select
    j3.n_name as n_name,
    j3.l_extendedprice as l_extendedprice,
    j3.l_discount as l_discount
from
    $j3 as j3
join
    $j4 as j4
on
    j3.n_nationkey = j4.c_nationkey
    and j3.l_orderkey = j4.o_orderkey
);
select
    n_name,
    sum(l_extendedprice * ($z1_12 - l_discount)) as revenue
from
    $j5
group by
    n_name
order by
    revenue desc;

	iteration 0:	ok	9.630798s seconds
Query06:
Query text:
$z0_0100001_12 = 0.0100001;
$z0_06_12 = 0.06;
$border = Date("1994-01-01");
select
    sum(l_extendedprice * l_discount) as revenue
from
    `olap_yatests/tpch/s0_1/lineitem`
where
    l_shipdate >= $border 
    and l_shipdate < ($border + Interval("P365D"))
    and l_discount between $z0_06_12 - $z0_0100001_12 and $z0_06_12 + $z0_0100001_12
    and l_quantity < 24;

	iteration 0:	ok	2.571639s seconds
Query07:
Query text:
$z1_12 = 1;
$n = select n_name, n_nationkey from `olap_yatests/tpch/s0_1/nation` as n
    where n_name = 'FRANCE' or n_name = 'GERMANY';
$l = select 
    l_orderkey, l_suppkey,
    DateTime::GetYear(cast(l_shipdate as timestamp)) as l_year,
    l_extendedprice * ($z1_12 - l_discount) as volume
from 
    `olap_yatests/tpch/s0_1/lineitem` as l
where 
    l.l_shipdate between Date('1995-01-01') and Date('1996-12-31');
$j1 = select 
    n_name as supp_nation,
    s_suppkey
from 
    `olap_yatests/tpch/s0_1/supplier` as supplier
join 
    $n as n1
on 
    supplier.s_nationkey = n1.n_nationkey;
$j2 = select
    n_name as cust_nation,
    c_custkey
from 
    `olap_yatests/tpch/s0_1/customer` as customer
join 
    $n as n2
on 
    customer.c_nationkey = n2.n_nationkey;
$j3 = select
    cust_nation, o_orderkey
from 
    `olap_yatests/tpch/s0_1/orders` as orders
join 
    $j2 as customer
on 
    orders.o_custkey = customer.c_custkey;
$j4 = select
    cust_nation,
    l_orderkey, l_suppkey,
    l_year,
    volume
from 
    $l as lineitem
join 
    $j3 as orders
on 
    lineitem.l_orderkey = orders.o_orderkey;
$j5 = select
    supp_nation, cust_nation,
    l_year, volume
from 
    $j4 as lineitem
join 
    $j1 as supplier
on 
    lineitem.l_suppkey = supplier.s_suppkey
where (supp_nation = 'FRANCE' and cust_nation = 'GERMANY')
    OR (supp_nation = 'GERMANY' and cust_nation = 'FRANCE');
select
    supp_nation,
    cust_nation,
    l_year, 
    sum(volume) as revenue
from
    $j5 as shipping
group by
    supp_nation,
    cust_nation,
    l_year
order by
    supp_nation,
    cust_nation,
    l_year;

	iteration 0:	ok	4.379716s seconds
Query08:
Query text:
$z0_12 = 0.;
$z1_12 = 1;
$join1 = (
select
    l.l_extendedprice * ($z1_12 - l.l_discount) as volume,
    l.l_suppkey as l_suppkey,
    l.l_orderkey as l_orderkey
from
    `olap_yatests/tpch/s0_1/part` as p
join
    `olap_yatests/tpch/s0_1/lineitem` as l
on
    p.p_partkey = l.l_partkey
where
    p.p_type = 'ECONOMY ANODIZED STEEL'
);
$join2 = (
select
    j.volume as volume,
    j.l_orderkey as l_orderkey,
    s.s_nationkey as s_nationkey
from
    $join1 as j
join
    `olap_yatests/tpch/s0_1/supplier` as s
on
    s.s_suppkey = j.l_suppkey
);
$join3 = (
select
    j.volume as volume,
    j.l_orderkey as l_orderkey,
    n.n_name as nation
from
    $join2 as j
join
    `olap_yatests/tpch/s0_1/nation` as n
on
    n.n_nationkey = j.s_nationkey
);
$join4 = (
select
    j.volume as volume,
    j.nation as nation,
    DateTime::GetYear(cast(o.o_orderdate as Timestamp)) as o_year,
    o.o_custkey as o_custkey
from
    $join3 as j
join
    `olap_yatests/tpch/s0_1/orders` as o
on
    o.o_orderkey = j.l_orderkey
where o_orderdate between Date('1995-01-01') and Date('1996-12-31')
);
$join5 = (
select
    j.volume as volume,
    j.nation as nation,
    j.o_year as o_year,
    c.c_nationkey as c_nationkey
from
    $join4 as j
join
    `olap_yatests/tpch/s0_1/customer` as c
on
    c.c_custkey = j.o_custkey
);
$join6 = (
select
    j.volume as volume,
    j.nation as nation,
    j.o_year as o_year,
    n.n_regionkey as n_regionkey
from
    $join5 as j
join
    `olap_yatests/tpch/s0_1/nation` as n
on
    n.n_nationkey = j.c_nationkey
);
$join7 = (
select
    j.volume as volume,
    j.nation as nation,
    j.o_year as o_year
from
    $join6 as j
join
    `olap_yatests/tpch/s0_1/region` as r
on
    r.r_regionkey = j.n_regionkey
where
    r.r_name = 'AMERICA'
);
select
    o_year,
    sum(case
        when nation = 'BRAZIL' then volume
        else $z0_12
    end) / sum(volume) as mkt_share
from
    $join7 as all_nations
group by
    o_year
order by
    o_year;

	iteration 0:	ok	11.756395s seconds
Query09:
Query text:
$z1_12 = 1;
$p = (select p_partkey, p_name
from
    `olap_yatests/tpch/s0_1/part`
where p_name like '%green%');
$j1 = (select ps_partkey, ps_suppkey, ps_supplycost
from
    `olap_yatests/tpch/s0_1/partsupp` as ps
join $p as p
on ps.ps_partkey = p.p_partkey);
$j2 = (select l_suppkey, l_partkey, l_orderkey, l_extendedprice, l_discount, ps_supplycost, l_quantity
from
    `olap_yatests/tpch/s0_1/lineitem` as l
join $j1 as j
on l.l_suppkey = j.ps_suppkey AND l.l_partkey = j.ps_partkey);
$j3 = (select l_orderkey, s_nationkey, l_extendedprice, l_discount, ps_supplycost, l_quantity
from
    `olap_yatests/tpch/s0_1/supplier` as s
join $j2 as j
on j.l_suppkey = s.s_suppkey);
$j4 = (select o_orderdate, l_extendedprice, l_discount, ps_supplycost, l_quantity, s_nationkey
from
    `olap_yatests/tpch/s0_1/orders` as o
join $j3 as j
on o.o_orderkey = j.l_orderkey);
$j5 = (select n_name, o_orderdate, l_extendedprice, l_discount, ps_supplycost, l_quantity
from
    `olap_yatests/tpch/s0_1/nation` as n
join $j4 as j
on j.s_nationkey = n.n_nationkey
);
$profit = (select 
    n_name as nation,
    DateTime::GetYear(cast(o_orderdate as timestamp)) as o_year,
    l_extendedprice * ($z1_12 - l_discount) - ps_supplycost * l_quantity as amount
from $j5);
select
    nation,
    o_year,
    sum(amount) as sum_profit
from $profit
group by
    nation,
    o_year
order by
    nation,
    o_year desc;

	iteration 0:	ok	3.903494s seconds
Query10:
Query text:
$z1_12 = 1;
$border = Date("1993-10-01");
$join1 = (
select
    c.c_custkey as c_custkey,
    c.c_name as c_name,
    c.c_acctbal as c_acctbal,
    c.c_address as c_address,
    c.c_phone as c_phone,
    c.c_comment as c_comment,
    c.c_nationkey as c_nationkey,
    o.o_orderkey as o_orderkey
from
    `olap_yatests/tpch/s0_1/customer` as c
join
    `olap_yatests/tpch/s0_1/orders` as o
on
    c.c_custkey = o.o_custkey
where
    o.o_orderdate >= $border
    and o.o_orderdate < ($border + Interval("P92D"))
);
$join2 = (
select
    j.c_custkey as c_custkey,
    j.c_name as c_name,
    j.c_acctbal as c_acctbal,
    j.c_address as c_address,
    j.c_phone as c_phone,
    j.c_comment as c_comment,
    j.c_nationkey as c_nationkey,
    l.l_extendedprice as l_extendedprice,
    l.l_discount as l_discount
from
    $join1 as j 
join
    `olap_yatests/tpch/s0_1/lineitem` as l
on
    l.l_orderkey = j.o_orderkey
where
    l.l_returnflag = 'R'
);
$join3 = (
select
    j.c_custkey as c_custkey,
    j.c_name as c_name,
    j.c_acctbal as c_acctbal,
    j.c_address as c_address,
    j.c_phone as c_phone,
    j.c_comment as c_comment,
    j.c_nationkey as c_nationkey,
    j.l_extendedprice as l_extendedprice,
    j.l_discount as l_discount,
    n.n_name as n_name
from
    $join2 as j 
join
    `olap_yatests/tpch/s0_1/nation` as n
on
    n.n_nationkey = j.c_nationkey
);
select
    c_custkey,
    c_name,
    sum(l_extendedprice * ($z1_12 - l_discount)) as revenue,
    c_acctbal,
    n_name,
    c_address,
    c_phone,
    c_comment
from
    $join3
group by
    c_custkey,
    c_name,
    c_acctbal,
    c_phone,
    n_name,
    c_address,
    c_comment
order by
    revenue desc
limit 20;

	iteration 0:	ok	3.396551s seconds
Query11:
Query text:
$z0_0001_35 = 0.0001;
$scale_factor = 0.1;
$j1 = (
select
    s.s_suppkey as s_suppkey
from
    `olap_yatests/tpch/s0_1/supplier` as s
join
    `olap_yatests/tpch/s0_1/nation` as n
on
    n.n_nationkey = s.s_nationkey
where
    n.n_name = 'GERMANY'
);
$j2 = (
select
    ps.ps_partkey as ps_partkey,
    ps.ps_supplycost as ps_supplycost,
    ps.ps_availqty as ps_availqty
from
    `olap_yatests/tpch/s0_1/partsupp` as ps
join
    $j1 as j
on
    ps.ps_suppkey = j.s_suppkey
);
$threshold = (
select
    sum(ps_supplycost * ps_availqty) * $z0_0001_35 / $scale_factor as threshold
from
    $j2
);
$values = (
select
    ps_partkey,
    sum(ps_supplycost * ps_availqty) as value
from
    $j2
group by
    ps_partkey
);
select
    v.ps_partkey as ps_partkey,
    v.value as value
from
    $values as v
cross join
    $threshold as t
where
    v.value > t.threshold
order by
    value desc;

	iteration 0:	ok	5.587493s seconds
Query12:
Query text:
$join = (
    select
        l.l_shipmode as l_shipmode,
        o.o_orderpriority as o_orderpriority,
        l.l_commitdate as l_commitdate,
        l.l_shipdate as l_shipdate,
        l.l_receiptdate as l_receiptdate
    from
        `olap_yatests/tpch/s0_1/orders` as o
        join `olap_yatests/tpch/s0_1/lineitem` as l
        on o.o_orderkey = l.l_orderkey
);
$border = Date("1994-01-01");
select
    l_shipmode,
    sum(case
        when o_orderpriority = '1-URGENT'
            or o_orderpriority = '2-HIGH'
            then 1
        else 0
    end) as high_line_count,
    sum(case
        when o_orderpriority <> '1-URGENT'
            and o_orderpriority <> '2-HIGH'
            then 1
        else 0
    end) as low_line_count
from $join
where
    (l_shipmode = 'MAIL' or l_shipmode = 'SHIP')
    and l_commitdate < l_receiptdate
    and l_shipdate < l_commitdate
    and l_receiptdate >= $border
    and l_receiptdate < ($border + Interval("P365D"))
group by
    l_shipmode
order by
    l_shipmode;

	iteration 0:	ok	2.975777s seconds
Query13:
Query text:
$orders = (
    select
        o_orderkey,
        o_custkey
    from
        `olap_yatests/tpch/s0_1/orders`
    where
        o_comment NOT LIKE "%special%requests%"
);
select
    c_count as c_count,
    count(*) as custdist
from
    (
        select
            c.c_custkey as c_custkey,
            count(o.o_orderkey) as c_count
        from
            `olap_yatests/tpch/s0_1/customer` as c left outer join $orders as o on
                c.c_custkey = o.o_custkey
        group by
            c.c_custkey
    ) as c_orders
group by
    c_count
order by
    custdist desc,
    c_count desc;

	iteration 0:	ok	3.575158s seconds
Query14:
Query text:
$z100_35 = 100.;
$z0_12 = 0.;
$z1_12 = 1;
$border = Date("1995-09-01");
select
    $z100_35 * sum(case
        when p.p_type like 'PROMO%'
            then l.l_extendedprice * ($z1_12 - l.l_discount)
        else $z0_12
    end) / sum(l.l_extendedprice * ($z1_12 - l.l_discount)) as promo_revenue
from
    `olap_yatests/tpch/s0_1/lineitem` as l
join
    `olap_yatests/tpch/s0_1/part` as p
on
    l.l_partkey = p.p_partkey
where
    l.l_shipdate >= $border
    and l.l_shipdate < ($border + Interval("P30D"));

	iteration 0:	ok	2.481544s seconds
Query15:
Query text:
$z1_12 = 1;
$round = ($x, $y) -> { return Math::Round($x, $y); };
$border = Date("1996-01-01");
$revenue0 = (
    select
        l_suppkey as supplier_no,
        $round(sum(l_extendedprice * ($z1_12 - l_discount)), -8) as total_revenue
    from
        `olap_yatests/tpch/s0_1/lineitem`
    where
        l_shipdate  >= $border
        and l_shipdate < ($border + Interval("P91D"))
    group by
        l_suppkey
);
$max_revenue = (
select
    max(total_revenue) as max_revenue
from
    $revenue0
);
$join1 = (
select
    s.s_suppkey as s_suppkey,
    s.s_name as s_name,
    s.s_address as s_address,
    s.s_phone as s_phone,
    r.total_revenue as total_revenue
from
    `olap_yatests/tpch/s0_1/supplier` as s
join
    $revenue0 as r
on
    s.s_suppkey = r.supplier_no
);
select
    j.s_suppkey as s_suppkey,
    j.s_name as s_name,
    j.s_address as s_address,
    j.s_phone as s_phone,
    j.total_revenue as total_revenue
from
    $join1 as j
join
    $max_revenue as m
on
    j.total_revenue = m.max_revenue
order by
    s_suppkey;

	iteration 0:	ok	3.387166s seconds
Query16:
Query text:
$p = (
select
    p.p_brand as p_brand,
    p.p_type as p_type,
    p.p_size as p_size,
    ps.ps_suppkey as ps_suppkey
from
    `olap_yatests/tpch/s0_1/part` as p
join
    `olap_yatests/tpch/s0_1/partsupp` as ps
on
    p.p_partkey = ps.ps_partkey
where
    p.p_brand <> 'Brand#45'
    and p.p_type not like 'MEDIUM POLISHED%'
    and (p.p_size = 49 or p.p_size = 14 or p.p_size = 23 or p.p_size = 45 or p.p_size = 19 or p.p_size = 3 or p.p_size = 36 or p.p_size = 9)
);
$s = (
select
    s_suppkey
from
    `olap_yatests/tpch/s0_1/supplier`
where
    s_comment like "%Customer%Complaints%"
);
$j = (
select
    p.p_brand as p_brand,
    p.p_type as p_type,
    p.p_size as p_size,
    p.ps_suppkey as ps_suppkey
from
    $p as p
left only join
    $s as s
on
    p.ps_suppkey = s.s_suppkey
);
select
    j.p_brand as p_brand,
    j.p_type as p_type,
    j.p_size as p_size,
    count(distinct j.ps_suppkey) as supplier_cnt
from
    $j as j
group by
    j.p_brand,
    j.p_type,
    j.p_size
order by
    supplier_cnt desc,
    p_brand,
    p_type,
    p_size
;

	iteration 0:	ok	2.569348s seconds
Query17:
Query text:
$z7_35 = 7.;
$z0_2_12 = 0.2;
$p = select p_partkey from `olap_yatests/tpch/s0_1/part`
where
    p_brand = 'Brand#23'
    and p_container = 'MED BOX'
;
$threshold = (
select
    $z0_2_12 * avg(l_quantity) as threshold,
    l.l_partkey as l_partkey
from
    `olap_yatests/tpch/s0_1/lineitem` as l
left semi join
    $p as p
on  
    p.p_partkey = l.l_partkey
group by
    l.l_partkey
);
$l = select l.l_partkey as l_partkey, l.l_quantity as l_quantity, l.l_extendedprice as l_extendedprice
from
    `olap_yatests/tpch/s0_1/lineitem` as l
join
    $p as p
on  
    p.p_partkey = l.l_partkey;
select
    sum(l.l_extendedprice) / $z7_35 as avg_yearly
from
    $l as l
join
    $threshold as t
on  
    t.l_partkey = l.l_partkey
where
    l.l_quantity < t.threshold;

	iteration 0:	ok	9.431575s seconds
Query18:
Query text:
$in = (
select
    l_orderkey,
    sum(l_quantity) as sum_l_quantity
from
    `olap_yatests/tpch/s0_1/lineitem`
group by
    l_orderkey having
        sum(l_quantity) > 300
);
$join1 = (
select
    c.c_name as c_name,
    c.c_custkey as c_custkey,
    o.o_orderkey as o_orderkey,
    o.o_orderdate as o_orderdate,
    o.o_totalprice as o_totalprice
from
    `olap_yatests/tpch/s0_1/customer` as c
join
    `olap_yatests/tpch/s0_1/orders` as o
on
    c.c_custkey = o.o_custkey
);
select
    j.c_name as c_name,
    j.c_custkey as c_custkey,
    j.o_orderkey as o_orderkey,
    j.o_orderdate as o_orderdate,
    j.o_totalprice as o_totalprice,
    sum(i.sum_l_quantity) as sum_l_quantity
from
    $join1 as j
join
    $in as i
on
    i.l_orderkey = j.o_orderkey
group by
    j.c_name,
    j.c_custkey,
    j.o_orderkey,
    j.o_orderdate,
    j.o_totalprice
order by
    o_totalprice desc,
    o_orderdate,
    o_orderkey
limit 100;

	iteration 0:	ok	8.192155s seconds
Query19:
Query text:
$z1_12 = 1;
select
    sum(l.l_extendedprice* ($z1_12 - l.l_discount)) as revenue
from
    `olap_yatests/tpch/s0_1/lineitem` as l
join
    `olap_yatests/tpch/s0_1/part` as p
on
    p.p_partkey = l.l_partkey
where
    (
        p.p_brand = 'Brand#12'
        and (p.p_container = 'SM CASE' or p.p_container = 'SM BOX' or p.p_container = 'SM PACK' or p.p_container = 'SM PKG')
        and l.l_quantity >= 1 and l.l_quantity <= 1 + 10
        and p.p_size between 1 and 5
        and (l.l_shipmode = 'AIR' or l.l_shipmode = 'AIR REG')
        and l.l_shipinstruct = 'DELIVER IN PERSON'
    )
    or
    (
        p.p_brand = 'Brand#23'
        and (p.p_container = 'MED BAG' or p.p_container = 'MED BOX' or p.p_container = 'MED PKG' or p.p_container = 'MED PACK')
        and l.l_quantity >= 10 and l.l_quantity <= 10 + 10
        and p.p_size between 1 and 10
        and (l.l_shipmode = 'AIR' or l.l_shipmode = 'AIR REG')
        and l.l_shipinstruct = 'DELIVER IN PERSON'
    )
    or
    (
        p.p_brand = 'Brand#34'
        and (p.p_container = 'LG CASE' or p.p_container = 'LG BOX' or p.p_container = 'LG PACK' or p.p_container = 'LG PKG')
        and l.l_quantity >= 20 and l.l_quantity <= 20 + 10
        and p.p_size between 1 and 15
        and (l.l_shipmode = 'AIR' or l.l_shipmode = 'AIR REG')
        and l.l_shipinstruct = 'DELIVER IN PERSON'
    );

	iteration 0:	ok	2.859115s seconds
Query20:
Query text:
$z0_5_35 = 0.5;
$border = Date("1994-01-01");
$threshold = (
select
    $z0_5_35 * sum(l_quantity) as threshold,
    l_partkey as l_partkey,
    l_suppkey as l_suppkey
from
    `olap_yatests/tpch/s0_1/lineitem`
where
    l_shipdate >= $border
    and l_shipdate < ($border + Interval("P365D"))
group by
    l_partkey, l_suppkey
);
$parts = (
select
    p_partkey
from
    `olap_yatests/tpch/s0_1/part`
where
    p_name like 'forest%'
);
$join1 = (
select
    ps.ps_suppkey as ps_suppkey,
    ps.ps_availqty as ps_availqty,
    ps.ps_partkey as ps_partkey
from
    `olap_yatests/tpch/s0_1/partsupp` as ps
join any
    $parts as p
on
    ps.ps_partkey = p.p_partkey
);
$join2 = (
select
    distinct(j.ps_suppkey) as ps_suppkey
from
    $join1 as j
join any
    $threshold as t
on
    j.ps_partkey = t.l_partkey and j.ps_suppkey = t.l_suppkey
where
    j.ps_availqty > t.threshold
);
$join3 = (
select
    j.ps_suppkey as ps_suppkey,
    s.s_name as s_name,
    s.s_address as s_address,
    s.s_nationkey as s_nationkey
from
    $join2 as j
join any
    `olap_yatests/tpch/s0_1/supplier` as s
on
    j.ps_suppkey = s.s_suppkey
);
select
    j.s_name as s_name,
    j.s_address as s_address
from
    $join3 as j
join
    `olap_yatests/tpch/s0_1/nation` as n
on
    j.s_nationkey = n.n_nationkey
where
    n.n_name = 'CANADA'
order by
    s_name;

	iteration 0:	ok	4.836537s seconds
Query21:
Query text:
$n = select n_nationkey from `olap_yatests/tpch/s0_1/nation`
where n_name = 'SAUDI ARABIA';
$s = select s_name, s_suppkey from `olap_yatests/tpch/s0_1/supplier` as supplier
join $n as nation
on supplier.s_nationkey = nation.n_nationkey;
$l = select l_suppkey, l_orderkey from `olap_yatests/tpch/s0_1/lineitem`
where l_receiptdate > l_commitdate;
$j1 = select s_name, l_suppkey, l_orderkey from $l as l1
join $s as supplier
on l1.l_suppkey = supplier.s_suppkey;
$j2 = select l1.l_orderkey as l_orderkey, l1.l_suppkey as l_suppkey, l1.s_name as s_name, l2.l_receiptdate as l_receiptdate, l2.l_commitdate as l_commitdate from $j1 as l1
join `olap_yatests/tpch/s0_1/lineitem` as l2
on l1.l_orderkey = l2.l_orderkey
where l2.l_suppkey <> l1.l_suppkey;
$j2_1 = select s_name, l1.l_suppkey as l_suppkey, l1.l_orderkey as l_orderkey from $j1 as l1
left semi join $j2 as l2
on l1.l_orderkey = l2.l_orderkey;
$j2_2 = select l_orderkey from $j2 where l_receiptdate > l_commitdate;
$j3 = select s_name, l_suppkey, l_orderkey from $j2_1 as l1
left only join $j2_2 as l3
on l1.l_orderkey = l3.l_orderkey;
$j4 = select s_name from $j3 as l1
join `olap_yatests/tpch/s0_1/orders` as orders
on orders.o_orderkey = l1.l_orderkey
where o_orderstatus = 'F';
select s_name,
    count(*) as numwait from $j4
group by
    s_name
order by
    numwait desc,
    s_name
limit 100;

	iteration 0:	ok	6.165996s seconds
Query22:
Query text:
$z0_12 = 0.;
$customers = (
select
    c_acctbal,
    c_custkey,
    Substring(CAST(c_phone AS STRING), 0u, 2u) as cntrycode
from
    `olap_yatests/tpch/s0_1/customer`
);
$c = (
select
    c_acctbal,
    c_custkey,
    cntrycode
from
    $customers
where
    cntrycode = '13' or cntrycode = '31' or cntrycode = '23' or cntrycode = '29' or cntrycode = '30' or cntrycode = '18' or cntrycode = '17'
);
$avg = (
select
    avg(c_acctbal) as a
from
    $c
where
    c_acctbal > $z0_12
);
$join1 = (
select
    c.c_acctbal as c_acctbal,
    c.c_custkey as c_custkey,
    c.cntrycode as cntrycode
from
    $c as c
cross join
    $avg as a
where
    c.c_acctbal > a.a
);
$join2 = (
select
    j.cntrycode as cntrycode,
    c_custkey,
    j.c_acctbal as c_acctbal
from
    $join1 as j
left only join 
    `olap_yatests/tpch/s0_1/orders` as o
on
    o.o_custkey = j.c_custkey
);
select
    cntrycode,
    count(*) as numcust,
    sum(c_acctbal) as totacctbal
from
    $join2 as custsale
group by
    cntrycode
order by
    cntrycode;

	iteration 0:	ok	3.872555s seconds

Results for 1 iterations
┌─────────┬──────────┬─────────┬─────────┬─────────┬─────────┬───────────┬─────────┬─────────┬─────────┬─────────┬────────────────┬────────────────┬────────────────┬───────────┬──────────────┬────────────┬────────────┐
│ Query # │ ColdTime │ Min     │ Max     │ Mean    │ Median  │ UnixBench │ Std     │ RttMin  │ RttMax  │ RttAvg  │ CompilationMin │ CompilationMax │ CompilationAvg │ GrossTime │ SuccessCount │ FailsCount │ DiffsCount │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query01 │   2.584  │   2.584 │   2.584 │   2.584 │   2.583 │   2.584   │   0.001 │   0.038 │   0.038 │   0.038 │   0.227        │   0.227        │   0.227        │   2.621   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query02 │   3.355  │   3.355 │   3.355 │   3.355 │   3.355 │   3.355   │   0.000 │   0.101 │   0.101 │   0.101 │   0.520        │   0.520        │   0.520        │   3.456   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query03 │   4.561  │   4.561 │   4.561 │   4.561 │   4.561 │   4.561   │   0.000 │   0.055 │   0.055 │   0.055 │   0.293        │   0.293        │   0.293        │   4.616   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query04 │   4.713  │   4.713 │   4.713 │   4.713 │   4.712 │   4.713   │   0.001 │   0.056 │   0.056 │   0.056 │   0.313        │   0.313        │   0.313        │   4.769   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query05 │   9.531  │   9.531 │   9.531 │   9.531 │   9.530 │   9.531   │   0.001 │   0.100 │   0.100 │   0.100 │   0.342        │   0.342        │   0.342        │   9.631   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query06 │   2.527  │   2.527 │   2.527 │   2.527 │   2.527 │   2.527   │   0.000 │   0.045 │   0.045 │   0.045 │   0.092        │   0.092        │   0.092        │   2.572   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query07 │   4.320  │   4.320 │   4.320 │   4.320 │   4.319 │   4.320   │   0.001 │   0.060 │   0.060 │   0.060 │   0.363        │   0.363        │   0.363        │   4.380   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query08 │  11.465  │  11.465 │  11.465 │  11.465 │  11.465 │  11.465   │   0.000 │   0.291 │   0.291 │   0.291 │   0.677        │   0.677        │   0.677        │  11.756   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query09 │   3.770  │   3.770 │   3.770 │   3.770 │   3.769 │   3.770   │   0.001 │   0.134 │   0.134 │   0.134 │   0.367        │   0.367        │   0.367        │   3.903   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query10 │   2.865  │   2.865 │   2.865 │   2.865 │   2.864 │   2.865   │   0.001 │   0.532 │   0.532 │   0.532 │   0.664        │   0.664        │   0.664        │   3.397   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query11 │   3.890  │   3.890 │   3.890 │   3.890 │   3.889 │   3.890   │   0.001 │   1.698 │   1.698 │   1.698 │   0.421        │   0.421        │   0.421        │   5.587   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query12 │   2.927  │   2.927 │   2.927 │   2.927 │   2.926 │   2.927   │   0.001 │   0.049 │   0.049 │   0.049 │   0.340        │   0.340        │   0.340        │   2.976   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query13 │   3.521  │   3.521 │   3.521 │   3.521 │   3.521 │   3.521   │   0.000 │   0.054 │   0.054 │   0.054 │   0.255        │   0.255        │   0.255        │   3.575   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query14 │   2.455  │   2.455 │   2.455 │   2.455 │   2.455 │   2.455   │   0.000 │   0.026 │   0.026 │   0.026 │   0.168        │   0.168        │   0.168        │   2.482   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query15 │   3.261  │   3.261 │   3.261 │   3.261 │   3.260 │   3.261   │   0.001 │   0.127 │   0.127 │   0.127 │   0.373        │   0.373        │   0.373        │   3.387   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query16 │   2.409  │   2.409 │   2.409 │   2.409 │   2.409 │   2.409   │   0.000 │   0.160 │   0.160 │   0.160 │   0.421        │   0.421        │   0.421        │   2.569   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query17 │   9.345  │   9.345 │   9.345 │   9.345 │   9.344 │   9.345   │   0.001 │   0.087 │   0.087 │   0.087 │   0.303        │   0.303        │   0.303        │   9.432   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query18 │   8.110  │   8.110 │   8.110 │   8.110 │   8.110 │   8.110   │   0.000 │   0.082 │   0.082 │   0.082 │   0.484        │   0.484        │   0.484        │   8.192   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query19 │   2.829  │   2.829 │   2.829 │   2.829 │   2.829 │   2.829   │   0.000 │   0.030 │   0.030 │   0.030 │   0.278        │   0.278        │   0.278        │   2.859   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query20 │   4.469  │   4.469 │   4.469 │   4.469 │   4.468 │   4.469   │   0.001 │   0.368 │   0.368 │   0.368 │   0.618        │   0.618        │   0.618        │   4.837   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query21 │   6.034  │   6.034 │   6.034 │   6.034 │   6.034 │   6.034   │   0.000 │   0.132 │   0.132 │   0.132 │   0.539        │   0.539        │   0.539        │   6.166   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Query22 │   3.789  │   3.789 │   3.789 │   3.789 │   3.788 │   3.789   │   0.001 │   0.084 │   0.084 │   0.084 │   0.280        │   0.280        │   0.280        │   3.873   │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Sum     │ 102.729  │ 102.729 │ 102.729 │ 102.729 │ 102.718 │ 102.729   │   0.000 │   4.306 │   4.306 │   4.306 │   8.338        │   8.338        │   8.339        │  26.526   │ 22           │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ Avg     │   4.670  │   4.670 │   4.670 │   4.670 │   4.669 │   4.670   │   0.000 │   0.196 │   0.196 │   0.196 │   0.379        │   0.379        │   0.379        │   1.206   │ 22           │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼────────────────┼────────────────┼────────────────┼───────────┼──────────────┼────────────┼────────────┤
│ GAvg    │   4.155  │   4.155 │   4.155 │   4.155 │   4.155 │   4.155   │   0.000 │   0.101 │   0.101 │   0.001 │   0.347        │   0.347        │   0.001        │   0.000   │ 22           │            │            │
└─────────┴──────────┴─────────┴─────────┴─────────┴─────────┴───────────┴─────────┴─────────┴─────────┴─────────┴────────────────┴────────────────┴────────────────┴───────────┴──────────────┴────────────┴────────────┘

Results saved to f824baa9cfbbd7f7b5193c0ff93cc740.testuser.result
Json report saved to f824baa9cfbbd7f7b5193c0ff93cc740.testuser.stats.json
