|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
select n_name, o_year, sum(amount) as sum_profit from ( select n_name, DATE_PART('YEAR',o_orderdate) as o_year, l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount from part, supplier, lineitem, partsupp, orders, nation where s_suppkey = l_suppkey and ps_suppkey = l_suppkey and ps_partkey = l_partkey and p_partkey = l_partkey and o_orderkey = l_orderkey and s_nationkey = n_nationkey and p_name like '%green%' and s_acctbal :varies and ps_supplycost :varies ) as profit group by n_name, o_year order by n_name, o_year desc
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|