Welcome back

SELECT task_name, status, duration_ms
FROM etl_runs
WHERE started_at >= CURRENT_DATE
ORDER BY started_at DESC
LIMIT 50;

-- group success rate (last 7d)
SELECT
  client_id,
  store_id,
  ROUND(100.0 * SUM(CASE WHEN status='success' THEN 1 ELSE 0 END)/COUNT(*), 1) AS success_rate_pct
FROM etl_runs
WHERE started_at >= NOW() - INTERVAL '7 days'
GROUP BY client_id, store_id;