select
    nation,
    o_year,
    round(sum(amount), 2) as sum_profit
from
    (
        select
            n_name as nation,
            EXTRACT(YEAR FROM o_orderdate) as o_year,
            l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
        from
            {part_ds},
            {supplier_ds},
            {line_item_ds},
            {part_supp_ds},
            {orders_ds},
            {nation_ds}
        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%'
    ) as profit
group by
    nation,
    o_year
order by
    nation,
    o_year desc
