Year  | Store_format      | Category                      |Product        |   ABC_QNTY   |  ABC_RUB
2015  | Большой магазин   |  Игрушки для мальчиков        |    Халк       |        B     |      B
2016  | Маленький магазин |  Энергетические напитки       |    Заря       |        A     |      B

Select month, store_format, category, s.product
,case 
	when sales_qnty/sum(sales_qnty)*100 between 85 and 100  then 'A'
	when sales_qnty/sum(sales_qnty)*100 between 5 and 10  then 'B'
	when sales_qnty/sum(sales_qnty)*100 between 0 and 5  then 'C'
end as ABC_QNTY
,case
	when price/sum(price*sales_qnty)*100 between 85 and 100 then 'A'
	when price/sum(price*sales_qnty)*100  between 5 and 10 then 'B'
	when price/sum(price*sales_qnty)*100  between 0 and 5 then 'C'
end as ABC_RUB
from sale s 
join sprav sp ON sp.product=s.product
group by month, store_format,category,s.product,sales_qnty,price

Select LEFT(month,4) as year, s.store_format, sp.category, s.product
,case 
	when (sales_qnty/total_kolvo)*100 between 85 and 100  then 'A'
	when (sales_qnty/total_kolvo)*100 between 50 and 84  then 'B'
	when (sales_qnty/total_kolvo)*100 between 0 and 5  then 'C'
end as ABC_QNTY
,case
	when (price/total_sum)*100 between 85 and 100 then 'A'
	when (price/total_sum)*100  between 5 and 10 then 'B'
	when (price/total_sum)*100  between 0 and 5 then 'C'
end as ABC_RUB
from sale s
,(Select LEFT(month,4) as year, store_format, category, t2.product, sum(sales_qnty) as total_kolvo, sum(price*sales_qnty) as total_sum
 from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category,t2.product) as sq
 ,sprav sp 
where sq.product=s.product and sp.product=s.product
group by LEFT(month,4), s.store_format,sp.category,s.product

Select LEFT(month,4) as year, s.store_format, sp.category, s.product
,case 
	when (sum(sales_qnty)/(Select sum(sales_qnty) as total_kolvo from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category))*100 between 85 and 100  then 'A'
	when (sum(sales_qnty)/(Select sum(sales_qnty) as total_kolvo from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category))*100 between 5 and 10  then 'B'
	when (sum(sales_qnty)/(Select sum(sales_qnty) as total_kolvo from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category))*100 between 0 and 5  then 'C'
end as ABC_QNTY
,case
	when (sum(price)/(Select sum(price*sales_qnty) as total_sum from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category))*100 between 85 and 100 then 'A'
	when (sum(price)/(Select sum(price*sales_qnty) as total_sum from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category))*100 between 5 and 85 then 'B'
	when (sum(price)/(Select sum(price*sales_qnty) as total_sum from sale t1 join sprav t2 ON t1.product=t2.product
  group by LEFT(month,4), store_format,category))*100 between 0 and 5 then 'C'
end as ABC_RUB
from sale s
 ,sprav sp 
where sp.product=s.product
group by LEFT(month,4), s.store_format,sp.category,s.product