text: -- start query 1 in stream 0 using template query42.tpl and seed 1819994127
  select  dt.d_year
   	,item.i_category_id
   	,item.i_category
   	,sum(ss_ext_sales_price)
   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_manager_id = 1  	
   	and dt.d_moy=12
   	and dt.d_year=1998
   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 ;
  
  -- end query 1 in stream 0 using template query42.tpl
  