>
> doesn't anybody here an an idea how to do the group by week select
> sql?
>

Don't forget that without some more work, you will be grouping by all
previous years week 1, 2, 3 etc

What you might forget is that you need to group by year, week

Alan