github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q17.sql (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      );