Use Ranking and Window functions withing EntityFramework Core for databases (RowNumber, Rank, DenseRank, Average, Sum, Min, Max), SubQueries and some .NET translated to SQL functions