0001 SELECT
0002 dt.d_year,
0003 item.i_category_id,
0004 item.i_category,
0005 sum(ss_ext_sales_price)
0006 FROM date_dim dt, store_sales, item
0007 WHERE dt.d_date_sk = store_sales.ss_sold_date_sk
0008 AND store_sales.ss_item_sk = item.i_item_sk
0009 AND item.i_manager_id = 1
0010 AND dt.d_moy = 11
0011 AND dt.d_year = 2000
0012 GROUP BY dt.d_year
0013 , item.i_category_id
0014 , item.i_category
0015 ORDER BY sum(ss_ext_sales_price) DESC, dt.d_year
0016 , item.i_category_id
0017 , item.i_category
0018 LIMIT 100
