title: mysql query for display top 5 average rates
body: <p><strong>Hello</strong>
  Suppose I have this table in mysql:</p>
  
  <p><a href="https://i.stack.imgur.com/o1kGz.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o1kGz.jpg" alt="enter image description here"></a></p>
  
  <p>and i need to get the top 5 movies rated.
  i need to calculate the average rate for each movie for example: movieID 12 = (9.5+9)/2 = 9.25 (Avg), and then display the top 5 rates.</p>
  
  <p>any help?</p>