SQL Server LAST_VALUE Function

var year = 2016;

var query = DbContext.Set<SalesVolume>()
    .Query((VwCategorySalesVolume salesVolume, SalesVolume alias) =>
    {
        var highestSalesVolume = AggregateBy(LAST_VALUE(salesVolume.CategoryName))
            .OVER(ORDER(BY(salesVolume.Qty))
                .RANGE()
                .BETWEEN(FrameBounds.UNBOUNDED_PRECEDING)
                .AND(FrameBounds.UNBOUNDED_FOLLOWING));

        var r = SELECT<SalesVolume>(salesVolume.CategoryName.@as(alias.CategoryName),
            salesVolume.Year.@as(alias.Year),
            salesVolume.Qty.@as(alias.Quantity),
            highestSalesVolume.@as(alias.VolumeCategory));
        FROM(salesVolume);
        WHERE(salesVolume.Year == year);

        return r;
    });

foreach (var salesVolume in query)
    Console.WriteLine((salesVolume.CategoryName, salesVolume.Year, salesVolume.Quantity, salesVolume.VolumeCategory));

var years = new int?[] { 2016, 2017 };

var query = DbContext.Set<SalesVolume>()
    .Query((VwCategorySalesVolume salesVolume, SalesVolume alias) =>
    {
        var highestSalesVolume = AggregateBy(LAST_VALUE(salesVolume.CategoryName))
            .OVER(PARTITION(BY(salesVolume.Year))
                .ORDER(BY(salesVolume.Qty))
                .RANGE()
                .BETWEEN(FrameBounds.UNBOUNDED_PRECEDING)
                .AND(FrameBounds.UNBOUNDED_FOLLOWING));

        var r = SELECT<SalesVolume>(salesVolume.CategoryName.@as(alias.CategoryName),
            salesVolume.Year.@as(alias.Year),
            salesVolume.Qty.@as(alias.Quantity),
            highestSalesVolume.@as(alias.VolumeCategory));
        FROM(salesVolume);
        WHERE(years.Contains(salesVolume.Year));

        return r;
    });

foreach (var salesVolume in query)
    Console.WriteLine((salesVolume.CategoryName, salesVolume.Year, salesVolume.Quantity, salesVolume.VolumeCategory));