title: Find the name and the average IMDb rating of those movie-genres whose average IMDb rating is greater than or equal to 7.5 in SQL
body: <p>I have a <code>movie</code> table inside my <code>Movie_Info</code> database which contains <code>Movie_Name</code>, <code>Movie_I</code>D, <code>IMDB_Rating</code>, <code>Genre</code> etc fields. Like this:</p>
  <p><a href="https://i.stack.imgur.com/2tYLF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2tYLF.jpg" alt="enter image description here" /></a></p>
  <p>Now I need to <strong>find the name(name of genre) and the average IMDb rating of those movie-genres whose average IMDb rating is greater than or equal to 7.5.</strong></p>
  <p>my approach is:</p>
  <pre><code>SELECT
          Genre
          ,AVG (IMDB_Rating) AS AVG_IMDB_Rating
      FROM
          movie
      WHERE
          AVG (IMDB_Rating) &gt;= 7.5
  ;
  </code></pre>
  <p>But it gives error. Please help me to write the proper SQL.</p>