Как создать SQL отчёт для QA?

QA отчёты через SQL: количество тестов по статусам, баги по severity. Пример: SELECT status, COUNT(*) as count, ROUND(COUNT(*) * 100.0 / SUM(COUNT(*)) OVER (), 2) as percentage FROM test_executions GROUP BY status. Отчёт по багам: SELECT DATE(created_at) as date, severity, COUNT(*) FROM bugs GROUP BY DATE(created_at), severity ORDER BY date DESC, severity. Тренд по времени: SELECT DATE_TRUNC('week', created_at) as week, COUNT(*) FROM bugs GROUP BY week. Выгружаем в CSV для Excel через \copy или COPY.