SELECT t.participants."videoindex-qa-agent" AS id, ROUND(AVG(r.result.similarity_score), 2) AS avg_similarity, COUNT(*) AS questions FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY id ORDER BY avg_similarity DESC, id;

SELECT t.participants."videoindex-qa-agent" AS id, r.result.episode AS episode, ROUND(AVG(r.result.similarity_score), 2) AS avg_similarity, COUNT(*) AS questions FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY id, episode ORDER BY id, avg_similarity DESC;

SELECT t.participants."videoindex-qa-agent" AS id, ROUND(AVG(CASE WHEN r.result.similarity_score >= 0.7 THEN 1 ELSE 0 END) * 100, 1) AS accuracy_pct, COUNT(*) AS questions FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY id ORDER BY accuracy_pct DESC, id;