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

     1  use tpch;
     2  select
     3  ps_partkey,
     4  sum(ps_supplycost * ps_availqty) as value
     5  from
     6  partsupp,
     7  supplier,
     8  nation
     9  where
    10  ps_suppkey = s_suppkey
    11  and s_nationkey = n_nationkey
    12  and n_name = 'JAPAN'
    13  group by
    14  ps_partkey having
    15  sum(ps_supplycost * ps_availqty) > (
    16  select
    17  sum(ps_supplycost * ps_availqty) * 0.0001000000
    18  from
    19  partsupp,
    20  supplier,nation
    21  where
    22  ps_suppkey = s_suppkey
    23  and s_nationkey = n_nationkey
    24  and n_name = 'JAPAN'
    25  )
    26  order by
    27  value desc
    28  ;
    29  ps_partkey	value