SQL · Atlassian · Medium
You are given two relational tables: team and game. team has the following columns: Column Type team_id INT PRIMARY KEY team_name VARCHAR(100) game has the following columns: Column Type game_id INT PRIMARY KEY team_id INT opponent_team_id INT date DATE season_year INT team_score INT opponent_team_score INT game_type VARCHAR(50) Each row in game represents one contest from the perspective of team_id: team_id scored team_score, while opponent_team_id scored…
Checking your access…