From the matches table, find the 5 matches with the highest total score. For each match return match_num, match_date, and the total score computed as host_team_score + guest_team_score (alias it total_score). Order by total_scoredescending and keep only the top 5 rows.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan