snippets

SELECT id, title, created_at
FROM posts
WHERE created_at > NOW() - INTERVAL '7 days'
  AND published = true
ORDER BY created_at DESC;