SQL Server RANK Function

var query = DbContext.Set<ProductRank>()
                .Query((Products products, ProductRank alias) =>
                {
                    var priceRank = AggregateBy(RANK())
                        .OVER(ORDER(BY(products.ListPrice).DESC));

                    var r = SELECT<ProductRank>(products.ProductId.@as(alias.Product.ProductId),
                        priceRank.@as(alias.Rank));
                    FROM(products);

                    return r;
                })
                .Include(r => r.Product);

foreach (var rank in query.Take(3))
    Console.WriteLine((rank.Product.ProductId, rank.Product.ProductName, rank.Product.ListPrice, rank.Rank));

var query = DbContext.Set<ProductRank>()
                .Query((Products products, ProductRank alias) =>
                {
                    var priceRank = AggregateBy(RANK())
                        .OVER(PARTITION(BY(products.BrandId))
                            .ORDER(BY(products.ListPrice).DESC));

                    var r = SELECT<ProductRank>(products.ProductId.@as(alias.Product.ProductId),
                        priceRank.@as(alias.Rank));
                    FROM(products);

                    return r;
                })
                .Where(r => r.Rank <= 3)
                .Include(r => r.Product);

foreach (var rank in query.Take(3))
    Console.WriteLine((rank.Product.ProductId, rank.Product.ProductName, rank.Product.ListPrice, rank.Rank));