Select LEFT(s.month,4) as year, s.store_format, s.product, s.SALES_QNTY as 'Кол-во продаж'
--,sum(s.SALES_QNTY) over() as 'Продано товаров'
--,100. *s.SALES_QNTY/sum(s.SALES_QNTY) over() as 'Доля товаров'
--,100. *sum(ss.SALES_QNTY)/sum(s.SALES_QNTY) over() as 'Доля товаров нараст'
,price*s.SALES_QNTY as 'Прибыль'
,100. *price*s.SALES_QNTY/sum(price*s.SALES_QNTY) over() as 'Доля прибыли'
,100. *sum(price*ss.SALES_QNTY)/sum(price*s.SALES_QNTY) over() as 'Доля прибыли нарастающ'
,case 
	when 100. *sum(ss.SALES_QNTY)/sum(s.SALES_QNTY) over() > 95  then 'C'
	when 100. *sum(ss.SALES_QNTY)/sum(s.SALES_QNTY) over() > 80  then 'B'
	else 'A'
end as ABC_QNTY
,case
	when 100. *sum(price*ss.SALES_QNTY)/sum(price*s.SALES_QNTY) over() > 95  then 'C'
	when 100. *sum(price*ss.SALES_QNTY)/sum(price*s.SALES_QNTY) over() > 80  then 'B'
	else 'A'
end as ABC_RUB

	from sale s, sale ss, sprav sp
	where 
	ss.SALES_QNTY>=s.SALES_QNTY and 
	sp.PRODUCT=s.PRODUCT 
	group by LEFT(s.month,4), s.store_format, s.product, s.SALES_QNTY,price
	--order by 'Доля товаров' desc
	order by 'Прибыль' desc

Select 
t.year
,t.store_format
,t.category
,t.product
--,SALES_QNTY
--,t.Dolya_Tovarov
--,100. *t.Summa_prodazh/t.VSEGO_PRODAZH as procent_qnty
--,t.ranks_ABC_QNTY
      ,case
			when 100. *t.Summa_prodazh/t.VSEGO_PRODAZH < 80 then 'A'
			when 100. *t.Summa_prodazh/t.VSEGO_PRODAZH between 80 and 95 then 'B'
      else 'C' end as ABC_QNTY
--,t.Dolya_Pribili
--,100. *t.Summa_pribili/t.VSEGO_PRIBIL as procent_rub
--,t.ranks_ABC_RUB
	   ,case
			when 100. *t.Summa_pribili/t.VSEGO_PRIBIL < 80 then 'A'
			when 100. *t.Summa_pribili/t.VSEGO_PRIBIL between 80 and 95 then 'B'
      else 'C' end as ABC_RUB
from (SELECT	LEFT(month,4) as year, s.store_format, sp.category, s.product
				,SALES_QNTY
				,100. *SALES_QNTY/sum(SALES_QNTY) over() as Dolya_Tovarov
				,sum(SALES_QNTY) over(order by SALES_QNTY DESC) as Summa_prodazh
				,rank() over(order by SALES_QNTY DESC) as ranks_ABC_QNTY
				,sum(SALES_QNTY) over() as VSEGO_PRODAZH
				,100. *PRICE*SALES_QNTY/sum(PRICE*SALES_QNTY) over() as Dolya_Pribili
				,sum(PRICE*SALES_QNTY) over(order by PRICE*SALES_QNTY DESC) as Summa_pribili
				,rank() over(order by PRICE*SALES_QNTY DESC) as ranks_ABC_RUB
				,sum(PRICE*SALES_QNTY) over() as VSEGO_PRIBIL
       FROM  sale s left join sprav sp ON sp.PRODUCT=s.PRODUCT
     ) as t
order by year