text: select  *
  from (select i_manager_id
               ,sum(ss_sales_price) sum_sales
               ,avg(sum(ss_sales_price)) over (partition by i_manager_id) avg_monthly_sales
        from item
            ,store_sales
            ,date_dim
            ,store
        where ss_item_sk = i_item_sk
          and ss_sold_date_sk = d_date_sk
          and ss_store_sk = s_store_sk
          and d_month_seq in (1200,1200+1,1200+2,1200+3,1200+4,1200+5,1200+6,1200+7,1200+8,1200+9,1200+10,1200+11)
          and ((    i_category in ('Books','Children','Electronics')
                and i_class in ('personal','portable','reference','self-help')
                and i_brand in ('scholaramalgamalg #14','scholaramalgamalg #7',
  		                  'exportiunivamalg #9','scholaramalgamalg #9'))
             or(    i_category in ('Women','Music','Men')
                and i_class in ('accessories','classical','fragrances','pants')
                and i_brand in ('amalgimporto #1','edu packscholar #1','exportiimporto #1',
  		                 'importoamalg #1')))
  group by i_manager_id, d_moy) tmp1
  where case when avg_monthly_sales > 0 then abs (sum_sales - avg_monthly_sales) / avg_monthly_sales else null end > 0.1
  order by i_manager_id
          ,avg_monthly_sales
          ,sum_sales
   limit 100
  