Ordering Results

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:

cypher
MATCH (m:Movie)
WHERE m.imdbRating IS NOT NULL
RETURN m.title, m.imdbRating
ORDER BY m.imdbRating DESC

How 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.