Course: Cypher Intermediate Queries , topic Testing List Inclusion has issues

General
1

The system is not accepting the correct answer - 18.

2

Here is a link to the challenge:

https://graphacademy.neo4j.com/courses/cypher-intermediate-queries/1-filtering-queries/06-c5-list-inclusion/

What @sangs has correctly pointed out is that there are 18 unique actors that acted in German movies. This is because the data in the graph has list elements that are "German" and list elements that are " German".
I will correct the solution code and the correct answer which should be 18 and not 3.

3

Can you please post a link to the question.

4

You are fast. You updated the answer. Wouldn’t it be better to correct the data so there are no leading and trailing spaces? In real life, the data would be cleaned to stop those characters. This distracts from learning the the goal of the problem.

5

https://community.neo4j.com/t5/graphacademy-discussions/problem-with-quot-intermediate-cypher-queries-course-quot/td-p/62037

6

Thanks Elaine :slightly_smiling_face:
(migrated from khoros post Re: Course: Cypher Intermediate Queries , topic Te... - Neo4j - 64024)

7

I agree. We do intend to clean the data in this graph, but unfortunately cleaning the data could break code in other places so we need to coordinate how it is done. We plan on doing this "sweep" of the sandbox data and the course code that access it when we upgrade the sandboxes to V5 of Neo4j. The time for this is yet to be determined.

8

Hi elaine, the suggested solution is giving 26 as result, another solution returns 5. But neither of those solutions provides unique actor names, so, its confusing :confused:

9

The instructions say to NOT count rows that have duplicate actor names so the correct answer is 18, not 26.

Elaine