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