/* Количество продаж товаров по месяцам */
select count(rs.OrderDateKey) as c,  t.EnglishMonthName, p.ProductKey
from FactResellerSales as rs inner join 
     DimProduct as p on rs.ProductKey=p.ProductKey inner join 
     DimTime as t on rs.OrderDateKey=t.TimeKey
group by t.EnglishMonthName, p.ProductKey
order by c desc
compute max(count(rs.OrderDateKey))