"Advent of Code" is released in December with daily questions. However, previous year questions are available and you can still do those without the pressure / friendly competition of trying to stay on the daily schedule. I like the questions a lot, but most are not ideal for SQL. I solved all of the 2020 questions with C#.
Another site I like a lot is projecteuler.net . These are mathematical puzzles, also not especially SQL-friendly.