📋 Report 3: Full Match Results

SELECT m.match_date, m.match_time, m.home_or_away, t.team_name, o.opponent_name, o.conference, m.team_score, m.opponent_score, m.result, v.venue_name, v.city, s.season_year FROM `match` m JOIN team t ON t.team_id = m.team_id JOIN opponent o ON o.opponent_id = m.opponent_id LEFT JOIN venue v ON v.venue_id = m.venue_id LEFT JOIN season s ON s.season_id = m.season_id ORDER BY m.match_date DESC;