Relational Db: Cannot get decimal places check of query results to pass

Curriculum Help
1

Tell us what’s happening:

Hello, when clicking Run in the coderoad window within vscode, a message appears saying the decimal places for some query results do not match, “the number of decimal places in some of the query results”. I compared the expected_output.txt file with the queries.sh output, and everything appears perfect, but this message appears every time I click Run. I am running the course locally on Windows 11 within vscode, it has given me other messages about a test not passing, and I have made changes and resubmitted by clicking Run, and then the test passes, but this particular test is not passing, I do not know why. Please let me know if there is some trick to get past this. I have regenerated the user token and rebuilt the container once already, truncated the tables and reran the insert_data.sh file, and all these steps got me past coderun being stuck after stopping and restarting the course, but I have done all steps quickly within an hour and cannot get past this, this seems like a very quirky thing, and I do not know what it wants me to do to make it think the decimal places are correct.
There are only three simple queries that produce numbers with decimal places, and the output of my queries match exactly:
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 deci>
2.13

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

lines from the queries.sh file:
echo -e “\nAverage number of goals in all games from the winning teams:”
echo “$($PSQL “select avg(winner_goals) from games”)”

echo -e “\nAverage number of goals in all games from the winning teams rounded t
o two decimal places:”
echo “$($PSQL “select round(avg(winner_goals),2) from games”)”

echo -e “\nAverage number of goals in all games from both teams:”
echo “$($PSQL “select avg(winner_goals + opponent_goals) from games”)”

Your code so far

see above

Lesson URL (copy - paste from your browser’s address bar)

https://raw.githubusercontent.com/freeCodeCamp/learn-world-cup-database/main/tutorial.json

2

Welcome to the forum @edu1

Please share a screen grab of the terminal, instructions and the output file.

Happy coding

3

Hello, thanks for replying so quickly. I apologize, I think I was wrong about the problem, and it will take me a while to perform a few tests, so this post has a bad description, and if I solve the problem, I think it will be a totally different solution, so if it’s possible to delete this post, I will post again if I can’t get the real problem solved. I think it is a problem with the way I wrote one of the queries for a different step, it’s not recognizing the results, so I will have to work on that. Thanks for your help.