I am currently stuck on the building a world cup database challenge. In the last task it says
You should correctly complete the queries in the
queries.shfile. Fill in each emptyechocommand to get the output of what is suggested with the command above it. Only use a single line like the first query. The output should match what is in theexample_output.txtfile
So, I checked my output of the queries.sh file which is the exact match of the expected_output.txt file. But still can’t pass the tests.
Please tell me what seems to be the problem.
here is my output in the terminal.
here is the expected_output.text file
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:
2014|Germany
2018|France
List of teams that start with 'Co':
Colombia
Costa Rica