title: I am trying to make a query work on a Sample Movie Database and I cannot pinpoint the error
body: <p>So I am trying to run the following query on the sample database found in <a href="https://www.databasestar.com/sample-database-movies/" rel="nofollow noreferrer">here</a>.</p>
  <p>The query is the following with its description:</p>
  <pre><code>-- Q12: List the count of top rated movies by genre.
  
  SELECT g.genre_name, COUNT(m.title) AS nr
  FROM movies.movie AS m
  INNER JOIN movies.movie_genres AS k ON m.movie_id = k .movie_id
  INNER JOIN movies.genre AS g ON k.genre_id = g.genre_id
  WHERE m.vote_average &gt;= ALL ( SELECT n.vote_average
                                FROM movies.movie AS n
                              )
  GROUP BY g.genre_name
  ORDER BY nr DESC
  </code></pre>
  <p>While I trying to run the code I am getting this error:
  <a href="https://i.stack.imgur.com/NU4I5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NU4I5.png" alt="Error image" /></a></p>
  <p>Personally I tried and couldn't pinpoint the issue at hand.</p>