text: -- tpch9 using 1395599672 as a seed to the RNG
  select
    nation,
    o_year,
    sum(amount) as sum_profit
  from
    (
      select
        n.n_name as nation,
        extract(year from o.o_orderdate) as o_year,
        l.l_extendedprice * (1 - l.l_discount) - ps.ps_supplycost * l.l_quantity as amount
      from
        cp.`tpch/part.parquet` p,
        cp.`tpch/supplier.parquet` s,
        cp.`tpch/lineitem.parquet` l,
        cp.`tpch/partsupp.parquet` ps,
        cp.`tpch/orders.parquet` o,
        cp.`tpch/nation.parquet` n
      where
        s.s_suppkey = l.l_suppkey
        and ps.ps_suppkey = l.l_suppkey
        and ps.ps_partkey = l.l_partkey
        and p.p_partkey = l.l_partkey
        and o.o_orderkey = l.l_orderkey
        and s.s_nationkey = n.n_nationkey
        and p.p_name like '%yellow%'
    ) as profit
  group by
    nation,
    o_year
  order by
    nation,
    o_year desc;