Leetcode力扣 MySQL数据库 1841 联赛信息统计

1841 联赛信息统计

SQL架构

Create table If Not Exists Teams_1841 (team_id int, team_name varchar(20));
Create table If Not Exists Matches_1841 (home_team_id int, away_team_id int, home_team_goals int, away_team_goals int);
Truncate table Teams_1841;
insert into Teams_1841 (team_id, team_name) values ('1', 'Ajax');
insert into Teams_1841 (team_id, team_name) values ('4', 'Dortmund');
insert into Teams_1841 (team_id, team_name) values ('6', 'Arsenal');
Truncate table Matches_1841;
insert into Matches_1841 (home_team_id, away_team_id, home_team_goals, away_team_goals) values ('1', '4', '0', '1');
insert into Matches_1841 (home_team_id, away_team_id, home_team_goals, away_team_goals) values ('1', '6', '3', '3');
insert into Matches_1841 (home_team_id, away_team_id, home_team_goals, away_team_goals) values ('4', '1', '