数据仓库服务 GaussDB(DWS)-TPC-H测试集:SQL9

时间：2025-02-12 14:55:03

SQL9

  
       selectnation,o_year,sum(amount) as sum_profitfrom(selectn_name as nation,extract(year from o_orderdate) as o_year,l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amountfrompart,supplier,lineitem,partsupp,orders,nationwheres_suppkey = l_suppkeyand ps_suppkey = l_suppkeyand ps_partkey = l_partkeyand p_partkey = l_partkeyand o_orderkey = l_orderkeyand s_nationkey = n_nationkeyand p_name like '%green%') as profitgroup bynation,o_yearorder bynation,o_year desc;