select
  s_name,
  s_address
from
  tpch1.soaeds.supplier,
  tpch1.soaeds.nation
where
  s_supplierkey in (
    select
      ps_supplierkey
    from
      tpch2.soaeds.partsupp
    where
      ps_partkey in (
        select
          p_partkey
        from
          tpch2.soaeds.part
        where
          p_name like 'powder%'
      )
      and ps_availqty > (
        select
          0.5 * sum(l_quantity)
        from
          tpch2.soaeds.lineitem
        where
          l_partkey = ps_partkey
          and l_supplierkey = ps_supplierkey
          and l_shipdate >=  '1994-01-01'
          and l_shipdate <  TIMESTAMPADD(SQL_TSI_YEAR,'1', '1994-01-01')
      )
  )
  and s_nationkey = n_nationkey
  and n_name = 'BRAZIL'
order by
  s_name;

SELECT g_0."PS_SUPPLIERKEY" AS c_0 FROM "SOAEDS"."PARTSUPP" g_0 WHERE g_0."PS_PARTKEY" IN (SELECT g_1."P_PARTKEY" FROM "SOAEDS"."PART" g_1 WHERE g_1."P_NAME" LIKE 'powder%') AND g_0."PS_AVAILQTY" > (SELECT (0.5 * SUM(g_2."L_QUANTITY")) FROM "SOAEDS"."LINEITEM" g_2 WHERE g_2."L_PARTKEY" = "SOAEDS"."PARTSUPP"."PS_PARTKEY" AND g_2."L_SUPPLIERKEY" = "SOAEDS"."PARTSUPP"."PS_SUPPLIERKEY" AND g_2."L_SHIPDATE" >= to_date('1994-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND g_2."L_SHIPDATE" < ?) ORDER BY c_0

SELECT smalla.intkey FROM smalla a