Great question! I've encountered similar week formatting challenges in SQL before. The weekofyear() function can sometimes behave unexpectedly depending on your database system and locale settings. I'd recommend checking if your system uses ISO week ...
