text: -- start query 12 in stream 0 using template query12.tpl
  select  i_item_desc 
        ,i_category 
        ,i_class 
        ,i_current_price
        ,sum(ws_ext_sales_price) as itemrevenue 
        ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over
            (partition by i_class) as revenueratio
  from	
  	web_sales
      	,item 
      	,date_dim
  where 
  	ws_item_sk = i_item_sk 
    	and i_category in ('Women', 'Children', 'Books')
    	and ws_sold_date_sk = d_date_sk
    	and ws_sold_date_sk between 2451959 and 2451989
  	and d_date between cast('2001-02-18' as timestamp) 
  				and (cast('2001-02-18' as timestamp) + interval 30 days)
  group by 
  	i_item_id
          ,i_item_desc 
          ,i_category
          ,i_class
          ,i_current_price
  order by 
  	i_category
          ,i_class
          ,i_item_id
          ,i_item_desc
          ,revenueratio
  limit 100;
  -- end query 12 in stream 0 using template query12.tpl
  