Perform the same query that was in the solution and the query throws me 1 more than the correct answer, it is possible that in a previous exercise some inspection has been added with the same city of NEW YORK, so which led me to answer incorrectly the number of inspections conducted in city of NEW YORK.
I reloaded the example data sheet and it brings me the correct amount ending in 9, effectively the information of the inspections was altered by a previous exercise, they should add as they did with the population a query of updating the data so that it is used properly. this was an issue on the part of the exercise.
Hi @Ruben_Betancourt, welcome to the community .
This is a known issue and has been addressed in this FAQ post.
However I will forward this feedback to the appropriate channel, and please be rest assured that our team is working on it.
In case you have any doubts, please feel free to reach out to us.
Thanks and Regards.
Curriculum Services Engineer