title: Calculating AVG and displaying top 10 score within a dog show database using MySql
body: <p>I hope everyone is doing well during this pandemic.</p>
  <p>I am a beginner and this is my first ever question so, I do apologise in advance for any error made.</p>
  <p>I am being asked to calculate the top 10 average scores of dogs which, attended at least more than one competition. To display their name, breed and average score. I am struggling to implement such query any help would be more than appreciated.</p>
  <p>To give you more an insight these are tables I am working with:</p>
  <pre><code>ENTRIES TABLE
  
  id | competition_id | dog_id | score 
   1          15            1       3
   2           8            3       9
   3           8            1       7
   4          13            3       6
  </code></pre>
  <p>DOGS TABLE</p>
  <pre><code>id  |  name  |  breed_id 
   1     Kieran      1
   2     Alexa       2
   3     Leah        3
   4     Sonia       4
  </code></pre>
  <p>BREEDS TABLE</p>
  <pre><code>id  |  name
   1     Bulldog
   2     Chihuahua
   3     Terrier
   4     Mastiff
  </code></pre>