;WITH cte AS
(
    SELECT X AS Rabontik, B Mesyac, ROW_NUMBER() OVER (PARTITION BY X ORDER BY B DESC) MesyacPoryadok, A Ocenka
    FROM dbo.Report
)
SELECT *
FROM cte
WHERE cte.MesyacPoryadok = 1 AND cte.Ocenka LIKE '%zaebal%'