imdb ratings
Movies with ratings
Write and execute a query to return the movie titles where they are ordered from the highest to the lowest imdbRating value. In your query, only return movies that have a value for the imdbRating property.
How many Movie titles are returned?
-
✓ 9058
Hint
Test the imdbRating value to make sure it exists.
Return the movie title and the imdbRating value. Make sure your results are ordered bny the imdbRating.
Once you have entered the answer, click the Try Again button below to continue.
Solution
You can run the following query to find the answer:
MATCH (m:Movie)
WHERE m.imdbRating IS NOT NULL
RETURN m.title, m.imdbRating
ORDER BY m.imdbRating DESCHow many movie titles does it return?
Once you have entered the answer, click the Try Again button below to continue.
Summary
In this challenge, you executed the query and answered a question about the data returned.
In the next challenge, you will write a query to return ordered results.