--- Jan Danielsson <jan(dot)m(dot)danielsson(at)gmail(dot)com> wrote:
>
> ----------------------
> select date_part('year', dt) as year, date_part('week', dt) as week,
> sum(amount) as asum
> from transactions
> group by year,week
having asum = (
select max(A.weeksum)
from
(
select sum(amount) as weeksum
from transactions
group by date_trunc('week', dt)
) A
)
> order by year,week;
> ----------------------
This should do what you want, but I expect that there is a better answer.
Regards,
Richard Broersma Jr.