I typically point folks here: https://pgexercises.com/

I like it because as a beginner you can just follow the learning path. But if you just need a refresher about how to write a window function you can jump right to that section.

Oh, and no account sign-ups which I really appreciate.