Untitled

select
       sum(case when date_trunc('day', now()) = date_trunc('day', paid_at) then amount else 0 end),
       sum(case when date_trunc('week', now()) = date_trunc('week', paid_at) then amount else 0 end),
       sum(case when date_trunc('month', now()) = date_trunc('month', paid_at) then amount else 0 end),
       sum(amount)
from payments