From the matches table, label the outcome of each match. Return match_num, host_team_id, guest_team_id, host_team_score, guest_team_score, and a computed column result that is 'Host win' when the host outscored the guest, 'Guest win' when the guest outscored the host, and 'Draw' when the scores are equal.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan