World Cup Database - Build a World Cup Database

I have completed the project but I still cannot get a check on the queries.sh despite getting the correct output. I have checked for typos on the output compared to other posts I read in the forum. The previous post was closed two days ago so I am unable to post my question there.

Your code so far

Total number of goals in all games from winning teams:
68

Total number of goals in all games from both teams combined:
90

Average number of goals in all games from the winning teams:
2.1250000000000000

Average number of goals in all games from the winning teams rounded to two decimal places:
2.13

Average number of goals in all games from both teams:
2.8125000000000000

Most goals scored in a single game by one team:
7

Number of games where the winning team scored more than two goals:
6

Winner of the 2018 tournament team name:
France

List of teams who played in the 2014 ‘Eighth-Final’ round:
Algeria
Argentina
Belgium
Brazil
Chile
Colombia
Costa Rica
France
Germany
Greece
Mexico
Netherlands
Nigeria
Switzerland
United States
Uruguay

List of unique winning team names in the whole data set:
Argentina
Belgium
Brazil
Colombia
Costa Rica
Croatia
England
France
Germany
Netherlands
Russia
Sweden
Uruguay

Year and team name of all the champions:
2018|France
2014|Germany

List of teams that start with ‘Co’:
Colombia
Costa Rica

Your browser information:

User Agent is: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0

Challenge: World Cup Database - Build a World Cup Database

Link to the challenge:

Make sure to compare it to the answers, and get it perfect. Case sensitivity, order or appearance and all.

1 Like

Thanks, man. I was going crossed eyed looking for differences and then your comment guided me to use the ‘diff’ command in bash to narrow it down. Found I was missing and ORDER BY for the champions.