Anyone here have good examples for querying objects based on relations? For example,

get the top 10 users with the most posts

I get that I could create an index for this, but what if I want to apply a time filter for most posts created within a time period?