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

     1  use tpch;
     2  with q15_revenue0 as (
     3  select
     4  l_suppkey as supplier_no,
     5  sum(l_extendedprice * (1 - l_discount)) as total_revenue
     6  from
     7  lineitem
     8  where
     9  l_shipdate >= date '1995-12-01'
    10  and l_shipdate < date '1995-12-01' + interval '3' month
    11  group by
    12  l_suppkey
    13  )
    14  select
    15  s_suppkey,
    16  s_name,
    17  s_address,
    18  s_phone,
    19  total_revenue
    20  from
    21  supplier,
    22  q15_revenue0
    23  where
    24  s_suppkey = supplier_no
    25  and total_revenue = (
    26  select
    27  max(total_revenue)
    28  from
    29  q15_revenue0
    30  )
    31  order by
    32  s_suppkey
    33  ;
    34  s_suppkey	s_name	s_address	s_phone	total_revenue
    35  1	Supplier#000000001	 N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ	27-918-335-1736	863528.2162