/* Количество продаж товаров по месяцам */ 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))