Demandez à Azul.

WITH drop AS (
  SELECT customer_id,
         AVG(events) FILTER (WHERE d > now() - '30d')
       - AVG(events) FILTER (WHERE d > now() - '90d') AS delta
  FROM   usage_events GROUP BY 1
)
SELECT c.name, d.delta, t.open_tickets, a.arr
FROM   drop d JOIN tickets t USING (customer_id)
        JOIN accounts a USING (customer_id)
ORDER  BY d.delta ASC LIMIT 10;

SELECT a.segment,
       SUM(i.amount - c.cogs - s.fees) /
       NULLIF(SUM(i.amount), 0) AS gross_margin
FROM   invoices i
       JOIN cogs    c USING (invoice_id)
       JOIN stripe.fees s USING (charge_id)
       JOIN accounts a USING (customer_id)
GROUP  BY 1
ORDER  BY 1;

SELECT o.stage,
       SUM(o.amount * p.probability) AS weighted
FROM   sf.opportunities o
       JOIN stage_probabilities p USING (stage)
WHERE  o.is_closed = false
GROUP  BY 1
ORDER  BY p.probability;

SELECT date_trunc('month', closed_at) AS m,
       AVG(EXTRACT(epoch FROM closed_at - opened_at)) / 3600
         AS avg_resolution_h
FROM   support.tickets
WHERE  status = 'resolved'
  AND  closed_at >= '2026-01-01'
GROUP  BY 1 ORDER BY 1;