code: def q11(partsupp, supplier, nation):
      partsupp_filtered = partsupp.loc[:, ["PS_PARTKEY", "PS_SUPPKEY"]]
      partsupp_filtered["TOTAL_COST"] = (
          partsupp["PS_SUPPLYCOST"] * partsupp["PS_AVAILQTY"]
      )
      supplier_filtered = supplier.loc[:, ["S_SUPPKEY", "S_NATIONKEY"]]
      ps_supp_merge = partsupp_filtered.merge(
          supplier_filtered,
          left_on="PS_SUPPKEY",
          right_on="S_SUPPKEY",
          how="inner",
      )
      ps_supp_merge = ps_supp_merge.loc[
          :, ["PS_PARTKEY", "S_NATIONKEY", "TOTAL_COST"]
      ]
      nation_filtered = nation[(nation["N_NAME"] == "GERMANY")]
      nation_filtered = nation_filtered.loc[:, ["N_NATIONKEY"]]
      ps_supp_n_merge = ps_supp_merge.merge(
          nation_filtered,
          left_on="S_NATIONKEY",
          right_on="N_NATIONKEY",
          how="inner",
      )
      ps_supp_n_merge = ps_supp_n_merge.loc[
          :, ["PS_PARTKEY", "TOTAL_COST"]
      ]
      sum_val = ps_supp_n_merge["TOTAL_COST"].sum() * 0.0001
      total = ps_supp_n_merge.groupby(
          ["PS_PARTKEY"], as_index=False, sort=False
      ).agg(VALUE=md.NamedAgg(column="TOTAL_COST", aggfunc="sum"))
      total = total[total["VALUE"] > sum_val]
      total = total.sort_values("VALUE", ascending=False)
      print(total.execute())
  
imports: import argparse
  import functools
  import time
  from typing import Callable, List, Optional, Set, Union
  import mars
  import mars.dataframe
label_desc: Use image node_id 20 for calling a global function with example usage: q11(partsupp, supplier, nation) without return types