text: select
      ps_partkey,
      sum(ps_supplycost * ps_availqty) as value
  from
      partsupp,
      supplier,
      nation
  where
          ps_suppkey = s_suppkey
    and s_nationkey = n_nationkey
    and n_name = 'GERMANY'
  group by
      ps_partkey having
          sum(ps_supplycost * ps_availqty) > (
          select
                  sum(ps_supplycost * ps_availqty) * 0.0001
          from
              partsupp,
              supplier,
              nation
          where
                  ps_suppkey = s_suppkey
            and s_nationkey = n_nationkey
            and n_name = 'GERMANY'
      )
  order by
      value desc;
  
  SELECT last_statement_duration_us / 1000000.0 last_statement_duration_seconds
  FROM current_session;