SQL

select
  id,
  name
from
  users
where
  created_at > now () - interval '7 days'
order by
  created_at desc;