Sqlite provider: IQueryable.Average() breaks after calling IQueryable.Select() containing window function

[AdamIzon]

Example:

var blockades = _dbContext.Blockades;
var testQuery = blockades.Select(b => EF.Functions.RowNumber(EF.Functions.Over().OrderBy((long)b.BlockadeStartIndex)));
var average = testQuery.Average();

throws: 'SQLite Error 1: 'misuse of window function ROW_NUMBER()'.'

I assume it's forming a query like this:

SELECT AVG(CAST(ROW_NUMBER() OVER(ORDER BY CAST("b"."BlockadeStartIndex" AS INTEGER)) AS REAL))
FROM "Blockade" AS "b"

which also throws "misuse of window function ROW_NUMBER()" when I execute the above query from the "DB Browser for Sqlite" GUI client

[AdamIzon]

can confirm EF Core is generating this sql code when calling "Average"

      SELECT AVG(CAST(ROW_NUMBER() OVER(ORDER BY CAST("b"."BlockadeStartIndex" AS INTEGER)) AS REAL))
      FROM "Blockade" AS "b"

after configuring ef core to log to console