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

     1  use tpch;
     2  select
     3  s_name,
     4  s_address
     5  from
     6  supplier,
     7  nation
     8  where
     9  s_suppkey in (
    10  select
    11  ps_suppkey
    12  from
    13  partsupp
    14  where
    15  ps_partkey in (
    16  select
    17  p_partkey
    18  from
    19  part
    20  where
    21  p_name like 'lime%'
    22  )
    23  and ps_availqty > (
    24  select
    25  0.5 * sum(l_quantity)
    26  from
    27  lineitem
    28  where
    29  l_partkey = ps_partkey
    30  and l_suppkey = ps_suppkey
    31  and l_shipdate >= date '1993-01-01'
    32  and l_shipdate < date '1993-01-01' + interval '1' year
    33  )
    34  )
    35  and s_nationkey = n_nationkey
    36  and n_name = 'VIETNAM'
    37  order by s_name
    38  ;
    39  s_name	s_address