Tell us what’s happening:
CodeRoad is not detecting results from queries.sh despite is giving the same results as expected_output.txt.
Your project link(s)
solution: GitHub - Lefp1122/Worldcup-Project
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36
Challenge: World Cup Database - Build a World Cup Database
Link to the challenge:
Results from querie.sh
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.81250000000000000000
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
Might seem a weird distinction but one of your results has 16 decimals places, where the expected_output has only 12.
Can you share your queries.sh code please? Wrap it in spoiler tags so others who haven’t yet solved this can’t see your solution.
Wow thank you, thats why it said to beware of the decimals. Solved.
Now i have to wait for FCC accept that it is done., so i can upload the link.
