github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q7.result (about) 1 use tpch; 2 select 3 supp_nation, 4 cust_nation, 5 l_year, 6 sum(volume) as revenue 7 from 8 ( 9 select 10 n1.n_name as supp_nation, 11 n2.n_name as cust_nation, 12 extract(year from l_shipdate) as l_year, 13 l_extendedprice * (1 - l_discount) as volume 14 from 15 supplier, 16 lineitem, 17 orders, 18 customer, 19 nation n1, 20 nation n2 21 where 22 s_suppkey = l_suppkey 23 and o_orderkey = l_orderkey 24 and c_custkey = o_custkey 25 and s_nationkey = n1.n_nationkey 26 and c_nationkey = n2.n_nationkey 27 and ( 28 (n1.n_name = 'FRANCE' and n2.n_name = 'ARGENTINA') 29 or (n1.n_name = 'ARGENTINA' and n2.n_name = 'FRANCE') 30 ) 31 and l_shipdate between date '1995-01-01' and date '1996-12-31' 32 ) as shipping 33 group by 34 supp_nation, 35 cust_nation, 36 l_year 37 order by 38 supp_nation, 39 cust_nation, 40 l_year 41 ; 42 supp_nation cust_nation l_year revenue 43 ARGENTINA FRANCE 1995 36554.0010 44 ARGENTINA FRANCE 1996 64102.9664