text: SELECT
    dt.d_year,
    item.i_category_id,
    item.i_category,
    sum(ss_ext_sales_price)
  FROM ${database}.date_dim dt, ${database}.store_sales, ${database}.item
  WHERE dt.d_date_sk = store_sales.ss_sold_date_sk
    AND store_sales.ss_item_sk = item.i_item_sk
    AND item.i_manager_id = 1
    AND dt.d_moy = 11
    AND dt.d_year = 2000
  GROUP BY dt.d_year
    , item.i_category_id
    , item.i_category
  ORDER BY sum(ss_ext_sales_price) DESC, dt.d_year
    , item.i_category_id
    , item.i_category
  LIMIT 100
  