How to filter a query based on row number using LINQ with Entity Framework I have the following query in MySQL (version 8+)
