text: SELECT
    dt.d_year,
    item.i_brand_id brand_id,
    item.i_brand brand,
    SUM(ss_ext_sales_price) sum_agg
  FROM date_dim dt, store_sales, 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_manufact_id = 128
    AND dt.d_moy = 11
  GROUP BY dt.d_year, item.i_brand, item.i_brand_id
  ORDER BY dt.d_year, sum_agg DESC, brand_id
  LIMIT 100
  