github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q17.result (about)

     1  use tpch;
     2  select
     3  sum(l_extendedprice) / 7.0 as avg_yearly
     4  from
     5  lineitem,
     6  part
     7  where
     8  p_partkey = l_partkey
     9  and p_brand = 'Brand#54'
    10  and p_container = 'LG BAG'
    11  and l_quantity < (
    12  select
    13  0.2 * avg(l_quantity)
    14  from
    15  lineitem
    16  where
    17  l_partkey = p_partkey
    18  );
    19  avg_yearly
    20  null