WITH revenue AS (
  SELECT account_id, SUM(amount) AS total
  FROM payments
  WHERE created_at >= DATE '2024-01-01'
  GROUP BY account_id
)
SELECT a.id, a.name, r.total
FROM accounts a
LEFT JOIN revenue r ON r.account_id = a.id
ORDER BY r.total DESC NULLS LAST;

-- Vorher: schwer lesbar
select id,name,created_at from users where status='active' and created_at>now()-interval '30 days';

-- Nachher: formatiert
SELECT
  id,
  name,
  created_at
FROM users
WHERE status = 'active'
  AND created_at > NOW() - INTERVAL '30 days';