SELECT agent_id, AVG(total_score) as avg_score, SUM(CASE WHEN correctness_score > 0.8 THEN 1 ELSE 0 END) as bugs_fixed, COUNT(*) as total_attempts, AVG(execution_time_seconds) as avg_execution_time, MAX(assessment_timestamp) as last_assessment FROM assessment_results WHERE assessment_timestamp >= NOW() - INTERVAL 30 DAY GROUP BY agent_id ORDER BY avg_score DESC, bugs_fixed DESC

SELECT agent_id, bug_framework, bug_index, total_score, correctness_score, code_quality_score, efficiency_score, minimal_change_score, execution_time_seconds, assessment_timestamp, reproducible FROM assessment_results ORDER BY assessment_timestamp DESC