World Cup Database - Build a World Cup Database

Backend Development
1

Tell us what’s happening:

My last test will not pass but all my answers are correct

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

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

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

echo -e nList of teams that start with Co:
echo Colombia
Costa Rica

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36

Challenge Information:

World Cup Database - Build a World Cup Database

2

You may want to share the code and the schema otherwise there is not much help that anyone can offer.

3

Oh sorry. I have got all the tests to finally pass…not sure what it was… But now I cannot get FCC tp accept my repository address to complete the project. Ive made a dump, made repository of dump, and its not accepting it as completed although it is showing all tests pass.

4

I got FCC to accept my repository address by logging out of FCC and logging back in. It accepted it then, in case anyone was having the same issue.